Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to pass more than one parameter to SQL script

How to pass more than one parameter to SQL script

From: <suisum_at_freenet.edmonton.ab.ca>
Date: 1997/11/03
Message-ID: <63ljh0$g1k$1@news.sas.ab.ca>#1/1

I have a UNIX script to call a SQL script:

   MaxWorkflowCases=$1
   PriorityLimit=$2
   sqlplus $SQLPLUS_SIGNON @$SQLPLUS_DIR/rccrwf.sql $MaxWorkflowCases $PriorityLimit

The SQL script:

   EXECUTE create_wf_cases_pr ('&1' '&2');

Please help. I got the following error:

  old 1: begin create_wf_cases_pr ('&1' '&2'); end;   new 1: begin create_wf_cases_pr ('100' '500'); end;

  begin create_wf_cases_pr ('100' '500'); end;

  *
  ERROR at line 1:
  ORA-06550: line 1, column 33:
  PLS-00103: Encountered the symbol "500" when expecting one of the following:
. ( ) , * @ % & | = - + < / > in mod not range rem => ..
  an exponent (**) <> or != or ~= >= <= <> and or etc.   The symbol "." was substituted for "500" to continue.

--
Best regards,
Received on Mon Nov 03 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US