Is there anyone who encountered the problem of Oracle 10 g, a merge statement, carry out no problem independently, but is an error in the process of storage, and submitted to the wrong information, such as: missing right parenthesis (because the merge separate execution are certainly wouldn't be missing right parenthesis), I put it in the process of storage period of the merge with dynamic statement, the process is not an error, and the merge on success, is someone you know why? Is not the process of dynamic statement, he will capture the merge period, because of the merge this statement is a bit long,

CodePudding user response:

Stored procedures can compile the past?

CodePudding user response:

reference 1st floor selling fruit net reply:

stored procedure can compile the past?

Can compile and execute the process error, I declare that the merge blocks to another wrong: parameter failure, according to the error message is the merge blocks like be intercepted, incomplete can offer mistake, statement I still work with dynamic statement, the merge of normal execution,

CodePudding user response:

To merge the statement into the strange characters from some invisible?

CodePudding user response:

reference minsic78 reply: 3/f

to merge, the statement is a strange character into some invisible?

No, if the statement execution alone will not pass