Hi! Well I am new to Oracle and I am having trouble using the stored procedures in Oracle. Lets get my problem straight: I have this proceudre in...

Hi! Well I am new to Oracle and I am having trouble using the stored procedures in Oracle. Lets get my problem straight: I have this proceudre in the package body called insert_into_form_general. What this procedure basically does is that it returns the record no of the current record and also does a insert into the table called FORM_GENERAL. The procedure takes in firstname, last name, phone, comment and they are coming in as VARCHAR2. I also have a output variable that returns the record no for the current record and it is returned as a NUMBER. Here is the definition of my procedure: PROCEDURE INSERT_FORM_GENERAL( fname_in IN VARCHAR2, lname_in IN VARCHAR2, phone_in IN VARCHAR2, comment_in IN VARCHAR2, id_out OUT NUMBER) IS NEW_ID_GENERAL INTEGER; BEGIN SELECT FORM_GENERAL_ID_SEQ.CURRVAL INTO NEW_ID_GENERAL FROM DUAL; id_out := NEW_ID_GENERAL + 7; INSERT INTO FORM_GENERAL (FIRST_NAME,LAST_NAME,PHONE,COMMENTS) VALUES (site_in,fname_in,lname_in,phone_in,comment_in); END; Now in my ASP code I have a form that takes in firstname, lastname...blah...blah..and when the user hits the submit button it takes him to a new asp page where the above procedure is called. The firstname , lastname are stored into the variable FNAME, LNAME..by doing a request.form and the same is done for comment and phone. And this is how I call the procedure: Set Comm = Server.CreateObject("ADODB.Command") Set comm.ActiveConnection = Session("Conn") comm.commandtype=4 comm.commandtext = "PACK_DIAG.INSERT_FORM_GENERAL(FNAME,LNAME,PHONE,COMMENT,OUTPUT_VAR)" comm.execute When this code is executed I get an error saying Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Oracle][ODBC][Ora]ORA-06550: line 1, column 37: PLS-00201: identifier 'FNAME' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored /ap_diag/County/form_general2.asp, line 43 Well, got any suggestion that can help me out???????