 |
| Zugg |
Posted: Sat May 21, 2005 5:49 pm
Stored Procedures in zApp |
|
Castaway
GURU
Joined: 10 Oct 2000
Posts: 793
Location: Swindon, England
|
 Posted: Fri Jun 03, 2005 12:12 pm
|
I'm fairly sure the answer to "Is EXEC standard", is no. (What a surprise) - Oracle has an "EXECUTE" which just wraps a begin/end around your procedure call, you can also just call it by name like a normal function "myproc();". db2 uses "CALL myproc();" and doesnt support the "just call it" method. SQLite doesnt have any, neither does MySQL before v5, (afaik). I cant seem to figure out how PostGres does it from their docs, but probably not EXEC :)
So good luck with that.. I havent actually looked yet, at why you would want to be able to call them directly.. I probably should.
Lady C. |
|
|
|
|
Zugg
MASTER
Joined: 25 Sep 2000
Posts: 23379
Location: Colorado, USA
|
Posted: Fri Jun 03, 2005 4:37 pm
|
Well, I'm glad to hear that stored procedures are mostly working.
The ZeosLib has a zStoredProc component that seems to handle the various stored procedure syntax differences between the different databases. It handles input parameters, but I'm not sure what it does with output parameters. It looks like it's set up for stored procedures that return data sets. So that might explain what people are seeing. |
|
|
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
