Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing parameters to stored procedure

807569Jul 11 2006 — edited Jul 11 2006

hi,
I want to know how do we pass parameters to stored procedures.i have made a function to create a stored procedure and another function to call it.While calling the stored procedure i need to specify parameters like suppose
Create procedure abc as Select * from authors where au_id='12344' and au_name='sau'.Now i want to call the stored procedure by passing the parameters 12344 and sau as runtime arguments .Could someone plz help me out with this.This is to be done for SqlServer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 8 2006

Added on Jul 11 2006

2 comments

325 views