Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling Oracle SP
Message
From
11/07/2000 13:47:04
 
 
To
11/07/2000 13:37:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00390579
Message ID:
00390842
Views:
21
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform