1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to pass an plsql text inside and parameter of a procedure

Discussion in 'SQL PL/SQL' started by Emmanurl, Jul 4, 2018.

  1. Emmanurl

    Emmanurl Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    GH
    how can I can pass a PLSQL text inside and parameter of a procedure whiles escaping it to be recognized as an executable script with a variable as well.
    Code (SQL):
    MYPROC.SCHED_SQL_QUERY(SQL_DATE=> SYSDATE, SQL_SCRIPT =>'BEGIN MYUTILITY.TEST(PID=> ' || T.ID || '); END;');
    . I get an error
    RA-06550: line 122, column 92:
    PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following:
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    769
    Likes Received:
    147
    Trophy Points:
    830
    Location:
    Russian Federation
    Provide here your source code of the procedure MYPROC.SCHED_SQL_QUERY