Home » SQL & PL/SQL » SQL & PL/SQL » Run script in OEM
Run script in OEM [message #220703] Wed, 21 February 2007 11:24 Go to next message
florida
Messages: 82
Registered: April 2006
Member
I have OEM and SQL Developer loaded on my Windows Workstation where both successfully connect to Oracle 9i Database.

I can successfully run sql scripts in the SQL Developer such as:
myScript.sql

myScript.sql is located in local location: \Documents and Settings\Smith.

The problem is I cant get a SQL script to run or work in OEM.
The error message: SP1-0310: Unable to open file "myScript.sql"
Re: Run script in OEM [message #220704 is a reply to message #220703] Wed, 21 February 2007 11:28 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
SP1-0310: Unable to open file "myScript.sql"

Are you sure given path is correct.

regards
Taj
Re: Run script in OEM [message #220706 is a reply to message #220704] Wed, 21 February 2007 11:38 Go to previous messageGo to next message
florida
Messages: 82
Registered: April 2006
Member
I run as @myScript.sql; in SQLDeveloper.

What or how would I find the path to run in OEM?
Re: Run script in OEM [message #220736 is a reply to message #220706] Wed, 21 February 2007 17:07 Go to previous message
florida
Messages: 82
Registered: April 2006
Member
Thanks,

I see you meant that I use the path for where script is located.
It now works.
Previous Topic: COUNT THE NUMBER OF ROWS IN A TABLE
Next Topic: SCRIPT SHELL How send some files in the same mail??
Goto Forum:
  


Current Time: Thu Dec 08 04:13:38 CST 2016

Total time taken to generate the page: 0.07177 seconds