Paste the procedure definition (first few lines where you define in out parameters) here in the message to see if the sequence of parameter is matching with the procedure definition. Message ” PLS-00306: wrong number or types of arguments in call” tells either the parameter sequence is incorrect or parameter type is incorrect. Jimmy ******************** SQL> Variable v1 CHAR SQL> Variable v2 NUMBER SQL> Variable v3 NUMBER SQL> Variable v4 CHAR SQL> Variable v5 CHAR SQL> Variable v6 varchar2 SQL> exec Bysheet (:v1,:v2,:v3,:v4,:v5,:v6,’G100′,1,6) īelow is original procedure: First package: CREATE OR REPLACE package types as type cursorType is ref cursor end ĪS PROCEDURE spGetDocumentsBySheet(p_cursor OUT Types.cursorType, p_DocumentType IN VARCHAR2, p_SheetStart IN NUMBER, p_SheetEnd IN NUMBER) ĬREATE OR REPLACE PACKAGE BODY Get_OMS_Taginfo AS PROCEDURE spGetDocumentsBySheet(p_cursor OUT Types.cursorType, p_DocumentType IN VARCHAR2, p_SheetStart IN NUMBER, p_SheetEnd IN NUMBER) AS BEGIN OPEN p_cursor FOR SELECT DISTINCT lib.sht_no AS “sheet” ,lib.dwg_id AS “docid” ,lib.dwg_ver AS “version” ,lib.rev AS “revision” ,lib.Status AS “status” ,fil.file_path AS “filepath” FROM lib_dwg lib ,tddi.file_path fil WHERE fil.dwg_id = lib.dwg_id AND lib.SEQ_NO = p_DocumentType AND DECODE(REPLACE( TRANSLATE( lib.sht_no,’0123456789.’,’00000000000′ ), ‘0’, ” ), ‘ ‘,TO_NUMBER(sht_no), NULL) BETWEEN To_number(p_SheetStart) AND To_number(p_SheetEnd) ORDER BY lib.sht_no ,lib.dwg_id ,lib.dwg_ver ,lib.rev which is wrong? I did not find any parameter sequence, there are 4 parmeter and first parmeter is Types.cursorType. Hi Shahzad, Thanks for your help!! could check my original SQL. SQL> SQL> Variable v1 CHAR SQL> Variable v2 NUMBER SQL> Variable v3 NUMBER SQL> Variable v4 CHAR SQL> Variable v5 CHAR SQL> Variable v6 varchar2 SQL> exec Bysheet (‘G100’,1,6,:v1,:v2,:v3,:v4,:v5,:v6) SQL> SQL> Variable v1 CHAR SQL> Variable v2 NUMBER SQL> Variable v3 NUMBER SQL> Variable v4 CHAR SQL> Variable v5 CHAR SQL> Variable v6 varchar2 SQL> exec Bysheet (:v1,:v2,:v3,:v4,:v5,:v6,’G100′,1,6)
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to ‘BYSHEET’ ORA-06550: line 1, column 7: PL/SQL: Statement ignored v1. SQL> Variable v1 CHAR SQL> Variable v2 NUMBER SQL> Variable v3 NUMBER SQL> Variable v4 CHAR SQL> Variable v5 CHAR SQL> Variable v6 varchar2 SQL> exec Bysheet (:v1,:v2,:v3,:v4,:v5,:v6,’G100′,1,6) the error message as PLS-00306: wrong number or types of arguments in call to ‘BYSHEET’ To see the values in out parameters use Print v1 Print v2
Ora 01008 pl sql developer archive#
Original Message Follows- Archive Page – ĭo something like this from sqlplus prompt Variable v1 varchar2(100) Variable v2 varchar2(100) exec Get_OMS_taginfo.Spgetdocumentsbysheet(‘G100’,1,6, :v1, :v2) SQL> var v2 NUMBER SQL> var v3 NUMBER SQL> var v4 CHAR SQL> var v5 CHAR SQL> var v6 varchar2 SQL> exec Bysheet (:v1,:v2,:v3,:v4,:v5,:v6,’G100′,1,6) SQL> var v3 NUMBER(3) NUMBER(3) unknown datatype SQL> SQL> var v1 CHAR(6), SQL> var v2 NUMBER(8) NUMBER(8) unknown datatype SQL> var v2 NUMBER SQL> var v3 NUMBER SQL> var v4 CHAR SQL> var v5 CHAR SQL> var v6 varchar2 SQL> exec Bysheet (‘G100’,1,6,:v1,:v2,:v3,:v4,:v5,:v6) SQL> SQL> var v1 CHAR, CHAR, unknown datatype Thanks for your email and any help!! Jimmy var v2 NUMBER SQL> var v3 NUMBER SQL> var v4 CHAR SQL> var v5 CHAR SQL> var v6 varchar2 SQL> exec Bysheet (‘G100’,1,6,:v1,:v2,:v3,:v4,:v5,:v6)īegin Bysheet (‘G100’,1,6,:v1,:v2,:v3,:v4,:v5,:v6) end I still got error message as PLS-00306: wrong number or types of arguments in call to ‘BYSHEET’ or ORA-01008: not all variables bound please see my copy of results even I put out this procedure as a independent procedure.
I try in different way to run this procedure. Tired of spam? Get advanced junk mail protection with MSN 8. ‘0’, ” ), ‘ ‘,TO_NUMBER(sht_no), NULL) BETWEEN To_number(p_SheetStart) PROCEDURE spGetDocumentsBySheet(p_cursor OUT Types.cursorType,ĬREATE OR REPLACE PACKAGE BODY Get_OMS_Taginfo ASĪND DECODE(REPLACE( TRANSLATE( lib.sht_no,’0123456789.’,’00000000000′ ), It works wellĬREATE OR REPLACE PACKAGE Get_OMS_Taginfo I got error message “”wrong number or types of arguments in call to When i user exec packagename.procedurenamr ( in-paramenter) asĮxec Get_OMS_taginfo.Spgetdocumentsbysheet(‘G100’,1,6) Could we use exec commond to execute a package procudure which have out