C0107 Compiler Error

Message text

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

Explanation

PowerBuilder has four dynamic SQL formats. If you use an OPEN or
EXECUTE statement with a descriptor, you must reference a dynamic cursor
or procedure.

Two statements in this example generate C0107 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;

// The following statements generate C0107
open dynamic curs using descriptor sqlda; 
execute dynamic proc using descriptor sqlda; 

// The following statements compile without error
open dynamic dyncurs using descriptor sqlda; 
execute dynamic dynproc using descriptor sqlda;

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;

// The following statements generate C0107

open dynamic curs using descriptor sqlda;

execute dynamic proc using descriptor sqlda;

// The following statements compile without error

open dynamic dyncurs using descriptor sqlda;

execute dynamic dynproc using descriptor sqlda;

See Also

FOR…NEXT in the section called “FOR…NEXT” in PowerScript Reference.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2019

August 21, 2023

Was this article helpful?

Connection Information

C0107 Compiler Error – PB Docs 2019

C0107 Compiler Error

My Website Links