SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
how to pass parameter to database stored proc

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
how to pass parameter to database stored proc
Author Message
Dominic Klein



Joined: 23 Nov 2001
Posts: 132

Post how to pass parameter to database stored proc ? Reply with quote

I want to execute an Oracle Stored Proc from JAL.
I want to pass the IN paramater as a variable (not hard-coded)

is this possible using DatabaseExecute ?
ie. Could I create a string that hold the command :

eg Create a JAL script that has a paramater p_proc_param

Dim (l_db_proc_string, string)

set (l_db_proc_string, "begin p_my_proc(")
concat (l_db_proc_string, p_proc_param, l_db_proc_string)
concat (l_db_proc_string, "); End;", l_db_proc_string)
DatabaseExecute(l_db_proc_string, result);

Would this work ?

Mon Feb 10, 2003 11:56 am View user's profile Send private message
Dominic Klein



Joined: 23 Nov 2001
Posts: 132

Post Re: how to pass parameter to database stored proc Reply with quote

I should have tried it to start with - yes it works !

Mon Feb 10, 2003 12:05 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.