I have a stored procedure within my Microsoft SQL server that I would like to call from ProIV. Does anyone know the syntax to use?
Click the link below to see the new game I'm developing!
SQL Stored Procedure
Started by
jconner
, Jan 31 2006 09:42 AM
4 replies to this topic
#3
andykay
-
- Members
-
- 204 posts
ProIV Guru
- Gender:Male
- Location:Cyberspace...looking for work
Posted 01 June 2006 - 09:08 PM
I try to do as little with the stored procedures as I can because they're a pain, but here's how we call them here.
PLSQLIN()
SQL
BEGIN
STORED_PROCEDURE_NAME(:PARM1,:PARM2,...,:PARM999) ;
END ;
PLSQLOUT()
HTH,
AK
PLSQLIN()
SQL
BEGIN
STORED_PROCEDURE_NAME(:PARM1,:PARM2,...,:PARM999) ;
END ;
PLSQLOUT()
HTH,
AK
THE LIGHT AT THE END OF THE TUNNEL IS THE HEADLAMP OF THE TRAIN THAT'S ABOUT TO HIT YOU!!!
#5
andykay
-
- Members
-
- 204 posts
ProIV Guru
- Gender:Male
- Location:Cyberspace...looking for work
Posted 02 June 2006 - 04:51 PM
JC,
The PLSQL statements are for some Global Logics that check for errors that may result from the SQL statement and then issue a ROLLBACK command if it finds one.
As I said, I try not to touch stored procedures because of the headaches they cause. You should be able to exclude the PLSQL statements, at your discretion, but you won't be able to issue a ROLLBACK command if you don't write similar code.
Good Luck,
AK
The PLSQL statements are for some Global Logics that check for errors that may result from the SQL statement and then issue a ROLLBACK command if it finds one.
As I said, I try not to touch stored procedures because of the headaches they cause. You should be able to exclude the PLSQL statements, at your discretion, but you won't be able to issue a ROLLBACK command if you don't write similar code.
Good Luck,
AK
THE LIGHT AT THE END OF THE TUNNEL IS THE HEADLAMP OF THE TRAIN THAT'S ABOUT TO HIT YOU!!!
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
Click the link below to see the new game I'm developing!
