Error in SqlPLSQLCommand

General discussion forum about all databases other than SqlBase.
Reinhard

Error in SqlPLSQLCommand

Post by Reinhard » 24 Oct 2007, 06:17

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

Re: Error in SqlPLSQLCommand

Post by Jean-Marc Gemperle » 30 Oct 2007, 12:56

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

Re: Error in SqlPLSQLCommand

Post by belitski » 30 Oct 2007, 14:08

Hi,

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

SqlOraPLSQL* it disapeared.



Vladimir

Jean-Marc Gemperle

Re: Error in SqlPLSQLCommand

Post by Jean-Marc Gemperle » 30 Oct 2007, 14:32

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

Re: Error in SqlPLSQLCommand

Post by Reinhard » 31 Oct 2007, 14:51

jmgemperle wrote: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

Re: Error in SqlPLSQLCommand

Post by garfae » 23 May 2008, 14:35

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

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests