Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I change the working directory in PL/SQL

Re: How do I change the working directory in PL/SQL

From: PMG <pete_g_at_2xtreme.net>
Date: Tue, 23 Feb 1999 06:18:06 GMT
Message-ID: <36D24827.43BD2BA8@2xtreme.net>


Search in the registry for the string SQLPATH (it should be found under HKEY_LOCAL_MACHINE, SOFTWARE, ORACLE), and then edit the SQLPATH entry by adding ";C:\MYQUERYS" (make sure there is a semicolon before your path) to the current value.

Wayne wrote:

> How do I change the working directory in PL/SQL so that when I type
> @xyz.sql and xyz.sql is in c:\myquerys it is found. Currently I have to
> type @c:\myquerys\xyz.
>
> Thanks,
>
> Wayne.
Received on Tue Feb 23 1999 - 00:18:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US