Title: RE: Stored Procedure with input parameters using esql?
You were right "in" works well ;)
This also worked for me:
--
{call get_person(NULL,NULL,NULL,'')}
--
Thanks!!
-
Title: RE: Stored Procedure with input parameters using esql?
You were right "in" works well ;)
This also works:
{call get_person(NULL,NULL,NULL,'')}
Thanks!!
-Original Message-
From: Paul Gilligan [mailto:[EM
inal Message-
> From: Naquin, Beth [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 31 May 2002 7:27
> To: '[EMAIL PROTECTED]'
> Subject: Stored Procedure with input parameters using esql?
>
> I want to execute a stored procedure that requires input par
Title: Stored Procedure with input parameters using esql?
Hi
Beth,
Just a
quick look at the esql stylesheet seems to indicate direction="in" not "In". XML
is case-sensitive!
HTH
Perry
-Original Message-From: Naquin, Beth
[mailto:[EMAIL PROTECTED]]Sent:
445')}
>
>
>
> Any ideas or example would be greatly appreciated !!
>
> Thx,
> Beth
>
>
> -Original Message-
> From: Paul Gilligan [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 30, 2002 2:33 PM
> To: [EMAIL PROTECTED]
> Subject: Re
#x27;46465445')}
>
>
>
> Any ideas or example would be greatly appreciated !!
>
> Thx,
> Beth
>
>
> -Original Message-
> From: Paul Gilligan [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 30, 2002 2:33 PM
> To: [EMAIL PROTECTED]
> Su
Title: RE: Stored Procedure with input parameters using esql?
Thanks for the quick reply! but I am still confused :(
The input arguments will eventually be user-entered data, but the user will only enter one of the four inputs, as they are mutually exclusive. (You could send data for all
Why are you using NULL??
Does not seem to understand the NULL which is why you get the error.
A better way would be to setup a default NULL argument for the PL/SQL
and then you can call:
{? = call get_person(?)}
..which Oracle will handle for you :)
Naquin, Beth wrote:
> I want to execute a
Title: Stored Procedure with input parameters using esql?
I want to execute a stored procedure that requires input parameters using the esql logicsheet, but am having difficulty. I can call stored procedures that take no inputs just fine.
Is there a working example/samle code of how to do