Load Package Wrapped

[dpsistemi]

Hi, I have a strange problem in load package wrapped.

I have same package Oracle wrapped.
My goal is read the source of package from system tables of oracle, and load this package in another schema of database.

Well, i load this source in TOraSQL or TOraScript, and execute.
The error is ORA-24344, and PLS-00801 : internal error [56106].

This error occured on only 2 my package, for the other no error

If I save this in a file, and use a SQLPlus, no error.

Thanks

Delphi 5.1 enterprice
ODAC 5.50.0.15

[Alex]

Sorry, we cannot reproduce your problem. We need more detailed description i.e. Oracle Client/Server version, complete sample to demonstrate your problem and script to create server objects.
Please, send a message to our ODAC support e-mail address.

[ChrisSlater]

Hi,

I am having the same/similar problem ("PLS-00801 : internal error [56104]"). I will work on getting you a sample that can reproduce the problem, but wanted to know if any progress has been made on this issue?

I need to solve this issue because if I can't our company will not be able to use ODAC. We would very much like to.

Thanks

[Alex]

We couldn't reproduce this problem wthout users' sample.

[ChrisSlater]

Hi, we seem to have found what the issue is here. When Oracle wraps code it can often have lines within the wrapped package that cause unterminated strings. These are usually caused by the desire to have a quote (represented by a double quote) stay in the code. IE the following code within a package :

stmt:='alter system kill session '||''''||p_sid||', '||p_serial||'''';

looks like this in the wrapped package :

1a alter system kill session :
1 ':

I don't begin to understand the ins and outs of Oracle's wrapping engine, and will not question why there is only one quote remaining, but the fact is that this single unterminated quote seems to cause the errors previously mentioned. SQL*Net and DOA handle this situation correctly. We would dearly like ODAC to be able to also.

[Challenger]

Please send to ODAC support address samples of unwrapped and wrapped package on which you get error.