1 2 Previous Next 19 Replies Latest reply on Sep 8, 2010 3:00 PM by CraigB Go to original post
      • 15. Re: ORA-6550 - Usually a PL/SQL compilation error.
        abladb
        Good Morning Craig,

        Thank you for answering again!!!

        I'll try what you say, and I'll answer back with the results.

        Thank you!!!

        PS: Actually, I think I started the block Manually. (!!!!)

        ;)

        Thank you for the links!!!
        • 16. Re: ORA-6550 - Usually a PL/SQL compilation error.
          abladb
          Ok. That was it!!! To make it with the wizzard!!! However, now I have another problem related to it. When executing the query, it doesn't return anything having the error Query caused no records to be retrieved. (FRM-40301), but it should return one register.

          I have tried to put the Param data (a number directly) at Query Data Source Arguments like:
          - Argument name: PARAM
          - Type: NUMBER
          - Mode: IN
          - Value: 1000000096

          instead of
          - Argument name: PARAM
          - Type: NUMBER
          - Mode: IN
          - Value: :BlockName.ItemName

          and it neither works!!!

          Then, I've tried to put the Param data at the procedure (using Toad), and it works. Returns one register.

          So, what now? Anything else to try??

          Editing:
          I'm realizing that when I create a Store Procedure using the Wizzard, the wizzard ask me to insert the procedure name I will use. When ''refreshing'' for comming up the colums to choose, a Forms Error comes up: FRM-10095: Assertion failed in iewbdbc_oracle_to_id, at C:\forms\101220\src\ie\iewbdb.c:724 twice, but after pressing OK, the columns come up, so I can choose the ones I need (all of them) and continue.

          I have pressed the Help button on this pop-up, and this is what it shows:
          - Cause:  An internal inconsistency was detected.
          - Action:  Contact an Oracle support representative, and proceed with caution.

          Could this be the answer of my new problem?

          Edited by: abladb on Sep 8, 2010 12:00 PM
          • 17. Re: ORA-6550 - Usually a PL/SQL compilation error.
            abladb
            Finally!!! I've got it!!!

            One of the columns I had was a TimeStamp Type, but forms do not recognize it, so it transformed it into Varchar2, and that was the final problem.

            I've got it!!!

            Thank you all for the help!!!

            :D
            • 18. Re: ORA-6550 - Usually a PL/SQL compilation error.
              abladb
              Special thanks to Craig, and to everyone who tried to help me.

              Read thread (2 pages) to have the answer.

              ^^
              • 19. Re: ORA-6550 - Usually a PL/SQL compilation error.
                CraigB
                Glad I could help! Thanks for posting the final solution so others can benefit from your experience!

                Craig...
                1 2 Previous Next