Toad for Oracle is the de facto Oracle developer and database administration software tool for SQL development and tasks. It's the top Oracle DBA tool. Deployment tips, questions, blogs and other technical materials related to Quest Toad for Oracle Trial 9. Buy a Quest TOAD for Oracle Professional Edition License 1 Seat 1 Year or other Developer Tools Software at CDW.com.

• Toad For Oracle Licensing

HOW TO ACTIVATE 'TOAD FOR ORACLE' for PSM_USERS OF CYBERARK

Hello dears

I installed and activate 'TOAD for ORACLE' on PSM _Server in order to connect on oracle target via CyberArk.

When i tries to connect to the target, via Cyberark, the PSM server run the TOAD for Oracle.exe, but they show on windows of Toad for Oracle as what it's not activate, so th econnection to the target fail. In my checking, i realise that TOAD for Oracle is only activate for my session on the PSM_Server and not for other session. Specially, the session that PSM Server use to run the software TOAD for Oracle. How can i resolve this? Anyone have one idea?

I'm using TOAD to develop a stored function in an Oracle database. When I click the 'run as script' button in TOAD, it tells me that the script was executed with 0 errors and 1 compile errors. Where do I see the specific compile error(s). I'm fairly new to TOAD so I might be missing something obvious about the interface like a tab/window to see such error messages.

5 Answers

You can either add SHOW ERRORS to the end of the script, which will print the error message(s) to the 'script output' tab, or compile the function using the 'Execute Statement' command in Toad, which will cause the errors to be displayed in a box at the bottom of the editor.

2 things you can do

1. goto Toad, schema browser, select Invalid Objects will tell you where to look.
2. then load the package into the editor and select the function, right click, compile, wioll show you the errors

Another option that worked for me was to open my script in the procedure editor and compile it there.

Toad For Oracle Licensing

Click on Database -> Procedure Editor in top tool bar.

Paste your code in this new editor window and execute by clicking green play button on top.

All the errors will be displayed in a new window at the bottom.

Not the answer you're looking for? Browse other questions tagged oracletoad or ask your own question.