Re: strange PL/SQL Error

Hi,

How do I enable 'Dynamic SQL'? - I figured out that the Problem is the MINUS Set Operator. Are there any Prerequisites I have to know about before using this Operator?

Thanks,

Sebastian

On Sun, 29 Jul 2001 18:27:30 +0200, Anette Hansen <Info_at_AHa-EDV.de> wrote:

>Sebastian Scholz schrieb:
>>
>> Hello,
>>
>> this is really strange: This Insert works well when I'm at the
>> Console:
>>
>> INSERT INTO CUSTOMERDATA.NEW_ASSETS (LOCATION, NEUEASSETSOI, VERS)
>> SELECT CODE, ROWNUM, 1 FROM
>> ((SELECT
>> (SA_ANLAGENKENNZ||OBJEKTTABELLE.SA_SUB||'-'||OBJEKTTABELLE.SA_SU) AS
>> CODE FROM OBJEKTTABELLE)
>> MINUS
>> (SELECT LOCATION FROM MNT.ASSET));
>>
>> However, I need this Code inside a stored Procedure.
>> But I get this Message from the Compiler:
>>
>> PLS-00707: unsupported construct or internal error [num]
>> Cause: At run time, this is an internal error. At compile time, it
>> indicates one of the following problems:
>> A call was made to a remote subprogram that has a parameter type or
>> default expression not supported at the calling site.
>> An incomplete upgrade or downgrade was done to a database that has
>> stored procedures. Perhaps incorrect versions of system packages such
>> as STANDARD.SQL were installed.
>> A compiler bug was encountered. In such cases, legal PL/SQL syntax
>> will fail to compile.
>>
>> I'm using Oracle Version 8.0.5 .
>>
>> Please help!
>>
>> Thank you in advance,
>> Sebastian
>
>Hello,
>
>it`s better you use Dynamic-SQL Package, because you can
>modify querried Table at runtime.
>
>Regards, Anette
  Received on Sun Jul 29 2001 - 11:51:59 CDT