Re: problem with stored procedure

Ed Stevens <nospam_at_noway.nohow> wrote in message news:<be7g2vovmcp9kg1j0di17jid029natkvd5_at_4ax.com>...
> Oracle 8.1.7 on NT
>
> Stored procedure that begins with
>
> CREATE OR REPLACE PROCEDURE nmm.Extract_User_Table
> (pi_FileName IN VARCHAR2,
> pi_FileDir IN VARCHAR2,
> pi_TableName IN VARCHAR2,
> pi_Delimeter IN OUT VARCHAR2,
> po_ErrorOut OUT NUMBER) IS
> /*******************************************************************************
> * DESCRITION:
> *
> ********************************************************************************/
>
> Runs fine in TOAD, supplying values for the input variables in the
> Debug | Set Parameters dialog.
>
> But in SQLPlus, I get this (the EXEC statement -- which may be wrapped
> in this msg -- is what I key in. The BEGIN statement is echoed back.)
>
> Connected.
> SQL> exec nmm.extract_user_table ('attribute_master.csv',
> 'abpserver1\data_log_files\logs', 'dsa.attribute_master', ',', '0')
> BEGIN nmm.extract_user_table("attribute_master.csv",
> "abpserver1\data_log_files\logs", "dsa.attribute_master", ",", 0);
> END;
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 30:
> PLS-00201: identifier 'attribute_master.csv' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
>
>
> SQL>
>
>
> It seems to be takeing a parameter value and interpreting it as an
> identifier name.
>
> ???

You have OUT parameters in your procedure and you are passing literal values for them instead of specifying target variables to accept the OUT values. This may not be the reason for your error but eventually you will run into PLS-00363. I would suggest you test your procedure from sqlplus inside a PLSQL block,

DECLARE
   Delimeter_ VARCHAR2(1) := ',';
   ErrorOut_ NUMBER;
BEGIN
   nmm.extract_user_table ('attribute_master.csv', ...., Delimeter_, ErrorOut_);
END;
/

Regards
/Rauf Sarwar Received on Fri Jan 17 2003 - 19:02:15 CST