Calling stored procedures without using named parameters?

Posts   
 
    
KAF
User
Posts: 18
Joined: 13-Oct-2005
# Posted on: 13-Oct-2005 14:10:45   

Hi,

I noticed that the generated code for stored procedures (ActionProcedures.cs) uses named parameters. Is it possible to get LLBLGen to generate code that uses "positional" parameters (that is, not using the parameter name)? Or could it be added to the "new feature" list?

I'm using an Oracle database with an adapter scenario.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 13-Oct-2005 14:40:00   

Is there a particular reason why you need this?

Frans Bouma | Lead developer LLBLGen Pro
KAF
User
Posts: 18
Joined: 13-Oct-2005
# Posted on: 13-Oct-2005 15:08:54   

The reason is because the database administrator wants to be able to refactor parameter names of stored procedure without regenerating the LLBLGen code. The database administrator wants to be able to change parameter names in the stored procedures, mainly because a parameter name sometimes are the same as a column name (put there by developers, obviously simple_smile ) and "cursors then get a naming conflict" (end qoute).

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 14-Oct-2005 12:59:14   

You should use a different daaAdapter.template template, and set the command.BindByName to false in the CallActionStoredProcedure and CallRetrievalStoredProcedure routine, after it's called. thre is no other way to call a proc without using parameter names, as you can't use '?' for the parameter name....

Frans Bouma | Lead developer LLBLGen Pro