ISQL*Plus

How to config iSQL Plus on computer without a domain

Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message "The server encountered an internal error or misconfiguration and was unable to complete your...

iSQLPlus creating packages with multiple procedures in it

Hi, I am a bit stuck i need to create a package which has a number of different procedures in it. The procedures work on their own however whenever i try to put them into a package they then don't work and i get the error package created with complication errors, however when i type show errors...

Oracle + iSQL*Plus - PLS-00103: Encountered the symbol "GRANT"

Hi, i am trying to create some new csdba users and assign some roles to them however i keep getting the following error message - 7/22 PLS-00103: Encountered the symbol "GRANT" when expecting one of the following: * & | - + / at mod remainder rem => .. <an expo nent (**)> || multiset ...

connect sys as sysdba

how to connect sys as sysdba in toad software and in isqlplus. When i tried in isqlplus and in toad by connecting as "sys as sysdba" i got the error. please give me a solution.