C0104 Compiler Error

Message text

Open/execute command with parameters must reference dynamic
cursor/procedure.

Explanation

PowerBuilder has four dynamic SQL formats. If you use an OPEN or
EXECUTE statement that has parameters, you must reference a dynamic cursor
or procedure. For more information, see the section called “SQL Statements” in PowerScript Reference for more
information.

Two statements in this example generate C0104 because they reference
a cursor or procedure that was not declared using the DYNAMIC
keyword:

int li_a

declare curs cursor for select emp_id from employee;
declare dyncurs dynamic cursor for sqlsa;
declare proc procedure for webchanged;
declare dynproc dynamic procedure for sqlsa;

open dynamic curs using :li_a; // generates C0104
execute dynamic proc using :li_a; // generates C0104

open dynamic dyncurs using :li_a; // ok
execute dynamic dynproc using :li_a;// ok

int li_a

declare curs cursor for select emp_id from employee;

declare dyncurs dynamic cursor for sqlsa;

declare proc procedure for webchanged;

declare dynproc dynamic procedure for sqlsa;

open dynamic curs using :li_a; // generates C0104

execute dynamic proc using :li_a; // generates C0104

open dynamic dyncurs using :li_a; // ok

execute dynamic dynproc using :li_a;// ok

See Also

Using dynamic SQL in the section called “Using
dynamic SQL” in PowerScript Reference.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2019

August 21, 2023

Was this article helpful?

Connection Information

C0104 Compiler Error – PB Docs 2019

C0104 Compiler Error

My Website Links