How to compile the Oracle stored procedure in the PB?
Why is it compiled after the completion of the "success, but there are compilation errors" ah, can see teach me,
How to compile successfully in PB?
My email [email protected], eldest brother, help me!

CodePudding user response:

To make sure your stored procedures is correct,
Second to perform dynamic sql1 is ok,

CodePudding user response:

Eldest brother, guarantee right,
To enter, after the completion of common PLSQL Developer, recompile the don't have any problem,
Is mainly in the PB "success, but there are compilation errors,"
How to compile in PB ah???

CodePudding user response:

Such as the name of the stored procedure is ABC
String ls_sql
Ls_sql='the alter procedure ABC compile'
The EXECUTE IMMEDIATE: ls_sql;

CodePudding user response:

I tried, I can't

CodePudding user response:

Solved, are much carriage returns,
As long as change "~ r ~ n" to char (10) is ok,

CodePudding user response:

Can complete the task, jie posted ^ & amp; ^

CodePudding user response:

As if it's not that simple, ha ha.

CodePudding user response:

Pick up points is king!