problem with stored procedure

From: Ed Stevens <nospam_at_noway.nohow>
Date: Fri, 17 Jan 2003 09:48:48 -0600
Message-ID: <be7g2vovmcp9kg1j0di17jid029natkvd5@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.

??? Received on Fri Jan 17 2003 - 09:48:48 CST