Re: Trouble calling Stored Procedures from SQL*Plus! Please help!

Kent,

This may seem like an obvious question, but if your DBA created the procedure, why can't he/she give you an example on how to call the procedure? Wouldn't your DBA be a better source for this information than the newsgroups?

Thanks,
Brian

"Kent P. Iler" wrote:
>
> Hi,
>
> Our DBA create this procedure to insert/update data in our tables. I'm
> trying to verify it with SQL*Plus, but I can't get the syntax right. Can
> someone please help?!
>
> The first 4 parameters are required, and the 3 output parameters. There are
> a total of 136 parameters, but the others are set to "default" if they
> aren't passed.
>
> How do you specify output variables for the output parameters, and call the
> stored procedure with SQL*Plus?
>
> If you would be willing to look at the code, I'll send you the Create Table
> scripts and the Stored Procedure (didn't want to waste bandwidth). If not,
> the correct syntax would be very helpful!
>
> Thank you for your help!
>
> -- Kent Iler
> ----------------------------------------------------------------------
> kent_at_iler.NOSPAM.com
> Please CC: all replies via e-mail
> Remove .NOSPAM from e-mail address
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================