Announcement

Collapse
No announcement yet.

Call oracle's procedure inside of an event

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Call oracle's procedure inside of an event

    Hello,

    I have a procedure with parameters in oracle, do you know how to achieve this task? I have tried sc_exec_sq without success:

    sc_exec_sql("BEGIN APPLY_PLAN('2016', '98', '02'); END");

    The following error is displayed:

    Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in C:\Program Files (x86)\NetMake\v81\wwwroot\scriptcase\app\proy\APP\ index.php on line 1089

    Thank you in advance.


  • #2
    I have confirmed that using ; (semicolon) breaks the compiled code generated by ScriptCase. However, still finding a way to call the procedure.

    Comment


    • #3
      Sc_exec_sql("call yourproc()");
      /Giuseppe

      Professional Scriptcase Services
      Some Customers opinions

      Comment


      • #4
        Works like a champ. Thank you!

        Comment

        Working...
        X