Error in SqlPLSQLCommand

[Reinhard]

Hi!

I'm running TD5.1 on WindowsXP Professional with Oracle9i.
There has been no connect-problem.
But with the first statement SqlPLSQLCommand I get the error

"Unrecoverable Error: The depth of function calls and messages has exceeded the capacity of the system."

(The code runs under TD3.1).

Any hints for a solution appreciated !

kind regards,
Reinhard

[Jean-Marc Gemperle]

Hi

I doubt this error is strictly related to SqlPLSQLCommand but you never know...I would believe it is the result of the SP that might be wrong and this error message a consequence in the program logic. This message is related to recursive problem in function call or messaging in general.

Can you try to change SqlPLSQLCommand to the SqlORA**() function, check if the call and the results of the SP are ok. We have no know issue that relates to SP invocation and this error for the moment.

Thanks
Jean-Marc

[belitski]

Hi,

yes, this must help. I also had this error message, but after change to

SqlOraPLSQL* it disapeared.



Vladimir

[Jean-Marc Gemperle]

Hi,

If really SqlPLSQLCommand causes this error just by calling it then I like to get a repro case on it if possible. SqlPLSQLCommand () is not deprecated AFAIK and if there is a problem we need to fix it.

Thanks

JM

[Reinhard]

Hi,

If really SqlPLSQLCommand causes this error just by calling it then I like to get a repro case on it if possible. SqlPLSQLCommand () is not deprecated AFAIK and if there is a problem we need to fix it.

Thanks
JM

Hi Jean-Marc,

thanks for your reply. I've a large application with so many SqlPLSQLCommand's.
The coding below causes the error described.

Code: Select all

Set slCommand = '

		DVPGPA01.GET_StrOneDvProgParamValue(
		npDvProgpNr,
		vspDvProgpProg,
		vspDvProgpBez,
		vspDefaultValueA,
		npCommitJn,
		vspDvProgpwValueA, nlError ) '

Call SQ_SqlAddStatementToProtocol( hgSql, slCommand, FALSE )

Set blOk = SqlPLSQLCommand( hgSql, slCommand )   <------------------

thanks and kind regards
Reinhard

[garfae]

Good day,

We are having similar problems with TD4.1. The "Unrecoverable Error: The depth of function calls and messages has exceeded the capacity of the system." seems to occur randomly (but possibly always on SqlImmediate()-related calls?)...

Any thoughts on this issue would be appreciated.

Thank you,
-Sp