Jump to content


Photo
- - - - -

SQL Stored Procedure


4 replies to this topic

#1 jconner

jconner

    Newbie

  • Members
  • Pip
  • 3 posts
  • Gender:Male

Posted 31 January 2006 - 09:42 AM

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?

#2 jconner

jconner

    Newbie

  • Members
  • Pip
  • 3 posts
  • Gender:Male

Posted 01 June 2006 - 08:47 PM

I am still having an issue with this, does anyone have any input?

#3 andykay

andykay

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 204 posts
  • 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
THE LIGHT AT THE END OF THE TUNNEL IS THE HEADLAMP OF THE TRAIN THAT'S ABOUT TO HIT YOU!!!

#4 jconner

jconner

    Newbie

  • Members
  • Pip
  • 3 posts
  • Gender:Male

Posted 02 June 2006 - 01:07 PM

Thank you for the reply!

What is PLSQLIN and PLSQLOUT? I get an error in the ProIV logic when I try to use them.

#5 andykay

andykay

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 204 posts
  • 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 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