>Yes it should, but personaly, I always use a user login for testing rather than mu own, just to make certain it works.
>The error you were getting makes me wonder though... Is your connection still good?
Yes, actually, the SQLExec() for the SP is just right after another SQLExec() for an Insert. Then another SQLExec() runs immediately after the SP SQLexec() to log the transaction into another Oracle table.
I really have a bad SQLExec() between two successful SQLExec()s.
The DBA also verified that the profile I used is a member of a Role Group that has proper rights to execute the SP.
I'm going to try using the 'BEGIN ... END' block syntax and just pad a linefeed character and see if this will work.
Really appreciate your help.
Ramil 7/11
ramil
~~ learning to stand still