DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: recursive SQL error

  1. #1
    Join Date
    Feb 2006
    Posts
    86

    recursive SQL error

    Hi

    i am creating a package body but while creating it i am gettting this error:
    " PDE-PUP001 ORA-00604: error occured at recursive sql level 1 "

    i had three independent procedures earlier. now i want to keep those 3 procedures in a Package body. i copy the code & pasted in the package body.
    out of 3 procedures , codes of 2 procedures were copied and package body was created sucessfully but while i copy the codes of 3rd procedure in the package body it gives me the above mentioned error.

    i also tried creating a sql file and then run that file on SQL promt.but again it gives me same error.

    early help in this matter is highly appreciated..

    thanx

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Please post the code.

  3. #3
    Join Date
    Feb 2006
    Posts
    86
    i am just putting all the three independant procedures in one package.
    the procedures are doing fine independantly but when i am copying the code from those procedures (by simple cut,copy & paste command) inside the package, its giving me error.



    thanx in advance

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    As Tamil said "post the code" of both your header and your body package.

    If you are doing copy/paste you are probably not following the appropriate syntax to build a package.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Feb 2006
    Posts
    86
    i am able to create two procedures inside the package body. the error is coming only when i paste third proc. even in that third proc i am able to paste 500 lines of code (out of total 1000 lines ). the error comes only when i paste rest of the code...... so that means third procedure is also created but only half of the code exits in the proc...syntax & everything is ok since it is not giving any compilation error to me....only when i paste rest of the 500 lines of code it gives me the error...

  6. #6
    Join Date
    Feb 2006
    Posts
    86
    is there anyone in this forum who can help me and sort my problem out.

  7. #7
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    I see... you are not posting your code no matter how many times you are asked to do it.

    Would you at least copy/paste -as opposed to typing it in- the whole error stack?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    did you miss the part where you were asked to post the code?

  9. #9
    Join Date
    Jan 2008
    Posts
    7
    binoyshil:

    If you're not comfortable posting your real code- due to security reason(s), create a pl/sql generic package code that would show the viewers exactly what you're requesting help for. This way, the viewers would understand your issue(s) as to render the necessary help.

    DSupp2008.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width