7 Replies Latest reply: Jan 31, 2013 6:35 AM by 988092 RSS

    Problem with DESC command

    988092
      Hello guys! I have a terrible issue to report:

      Every time I do a desc command, it closes the console window...

      like this

      "desc aTable"

      then it closes
      if I change the user for the admin, it works.
      First I though it was a permission problem. Then I created a synonym and did a "grant" command...
      It still closes the window with the normal user...

      Any ideas?

      Kind Regards,

      Fernando
        • 1. Re: Problem with DESC command
          yoonas
          Hi,

          Please always provide little info of your environment https://blogs.oracle.com/shay/entry/10_commandments_for_the_otn_fo

          Your versions(database,os etc)
          What tool are you using?
          Admin user , normal What do you mean os level ?

          Regards
          Yoonas
          • 2. Re: Problem with DESC command
            988092
            Hi! So here is the print screen that will help you guys (and hopefully, me) to understand what is happening

            [http://www.mediafire.com/view/?tg82xps3fkb48c2]

            So at this print screen, we see the user Sygno using the command Desc without problems.

            [http://www.mediafire.com/view/?5a3r6hb7jv065xq]
            This print is right before sending the command. After that it will close the window.

            PS: In the second print, it says (in portuguese): "(Print before execute, because after execute it exit the SQL)"
            • 3. Re: Problem with DESC command
              Andreas Weiden
              You are in the wrong forum. This forum is about oracle forms. The tool you use is SQL*Plus. You might try this forum iSQL*Plus
              • 4. Re: Problem with DESC command
                yoonas
                Did you try to use someother tool and fire the same command

                You are using 8.0.6.0.0 cleint, can you run the same commands on 9.2.0.8.0(the database) itself

                Try
                start>run>sqlplus - the command
                Or use anyother tools like sqldevelope....
                • 5. Re: Problem with DESC command
                  988092
                  Thanks Andreas Weiden for the warning, I was a little lost here at the site. If any moderators can change the thread to the right place I will appreciate.


                  yoonus, I can't change the client... My company does not allow changes in the versions of the applications ... It has a whole bureaucracy, homologation, etc...

                  I know it will mess a bit... but I hope you guys can find a solution!

                  Kind Regards,

                  Fernando
                  • 6. Re: Problem with DESC command
                    988092
                    Woah! I find out:

                    It was a mess with the synonymous and the grant. They changed something in the database...
                    Well after giving grant to every synonymous and trying the "trial and error"process I made it... hehe

                    Thanks everyone!
                    • 7. Re: Problem with DESC command
                      988092
                      After some "trial and error" find out that was some mess with the synonymous and the grant.