I have not experience your problem.
We change our stored procedures all the time without any change in ND projects.
In Oracle we are using synonyms for all tables and stored procedures.
I have done the same for SQL server and Sybase and have not seen this problem.
This assumes your parameter names and position and type did not change.
"Mary Hill" <[EMAIL PROTECTED]> wrote:
>>Whenever I recompile a stored procedure (paramter list remains>unchanged) that is
called>from one of my page java classes, I get the following>error:>>Common
Error
Handler:>Error code: 12>Error message [INVALIDPOSITION] Invalid
position
within RWDBStoredProc SISPROD.CREATERANKINPUT>Is terminal: No>Vendor
error 1:
0>Vendor error 2: 0>Vendor message 1: >Vendor message 2:
>triggerDatabaseErrorEvent:
execution of the DataObject 'DoPrCreateRankInput' has failed:>System error
code is
12 ([INVALIDPOSITION] Invalid position within RWDBStoredProc
SISPROD.CREATERANKINPUT)>Vendor
error#1 code is 0 ()>Vendor error#2 code is 0 ()>>I end up having to
recompile the
dataobject and sometimes the page class>to get the stored procedure.>>This is
problematic
in a production environment where we want to release>changes to the stored
procedure
but not have to change the NetDyn>project.>>I have seen other messages with
this
same error mentioned in the forum, but >no real solutions were given.>>Has
anyone
found a way around this problem?>>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
