I/O Error 267 using sqlplus in Tools

[Makker]

Hi

I have in my command editor an sqlplus script that I want to execute with sqlplus since it is not compatible with command window. So I configured a Tool to call sqlplus with connect and path to the file to execute.

But when I choose this sqlplus then I get I/O Error 267.

I use instant client, but it happens with both 10.1 and 10.2. On windows XP. Strangely it worked before.

Thanks in advance,
Martien

--- Info ---

PL/SQL Developer
Version 6.0.6.947 (MBCS)
02.27959 - Unlimited user license
Windows XP version 6,0 (build 2600) Service Pack 2

Physical memory : 2.088.308 kB (203.036 available)
Paging file : 4.029.084 kB (3.340.344 available)
Virtual memory : 2.097.024 kB (1.909.672 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins
*PL/SQL Developer CompareSource Plug-In version 2003/12/03 (C:\Program Files\PLSQL Developer\PlugIns\CompareSource.dll)
*PL/SQL Developer FindAll Plug-In version 2003/11/18 (C:\Program Files\PLSQL Developer\PlugIns\FindAll.dll)
*FTP File Interface 1.1 (C:\Program Files\PLSQL Developer\PlugIns\ftp.dll)
*Syntax HighLighting (1.1) (C:\Program Files\PLSQL Developer\PlugIns\HighLighting.dll)
*PasteOptions 1.2 (C:\Program Files\PLSQL Developer\PlugIns\PasteOptions.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
*PL/SQL Developer Scale Plug-In version 2003/11/13 (C:\Program Files\PLSQL Developer\PlugIns\Scale.dll)
*Shortcuts Plug-In v1.2 by Tiger (C:\Program Files\PLSQL Developer\PlugIns\shortcuts.dll)
*PL/SQL Developer Sort Plug-In version 2003-11-05 (C:\Program Files\PLSQL Developer\PlugIns\Sort.dll)
*Version Control Interface 1.2 (C:\Program Files\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
BPEL
CRMA
CRMC
CRMM
CRMT
...

Homes

DLLs
D:\oracle\product\10.2.0\client_1\oci.dll

TNS File
D:\oracle\admin\network\tnsnames.ora

Using
Home:
DLL: D:\oracle\product\10.2.0\client_1\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Character size: 1 byte(s)

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory

SOFTWARE\ORACLE\KEY_OraClient10g_home1
ORACLE_HOME = D:\oracle\product\10.2.0\client_1
ORACLE_HOME_NAME = OraClient10g_home1
ORACLE_GROUP_NAME = Oracle - OraClient10g_home1

SOFTWARE\ORACLE\Messenger
Fatal URL = http://rtc.oracle.com/imtapp/im/messenger/omreport.jsp

SOFTWARE\ORACLE\Messenger\Modules

SOFTWARE\ORACLE\Messenger\Setup
source_dir = C:\DOCUME~1\makker\LOCALS~1\Temp\RWT9E45.tmp
dest dir = C:\Program Files\Oracle\Messenger
auto_update =
SOFTWARE\ORACLE\Outlook Connector

SOFTWARE\ORACLE\Outlook Connector\3.6
AppPath = C:\Program Files\Oracle\Outlook Connector
CompanyName = Oracle Corporation
InstallKey =
SyncLog =
Version = 10.1.1
Label =
NoAccounts = InstallDate = 03071117216
UserID =
UserName = Internal Systems
CfgSettings =

--- Path ---

D:\oracle\product\10.2.0\client_1
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\Program Files\Symantec\pcAnywhere\

--- TNS names ---

# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

#Local
BPEL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vm-win2k-bpel)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bpel)
)
)

orcl10g =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vm-win2k-orcl)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
orcl10g1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vm-rhel3-orcl1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL1)
)
)
orcl10g2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vm-rhel3-orcl2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl2)
)
)
#Nuon
# ORKDEV02.nuon.local
ORKDEV02 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orak01)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORKDEV02)
)
)
ORKDES01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orak01)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORKDES01)
)
)

QD1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = r3ac201)(PORT = 1527))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = QD1)
)
)

#thebe
CRMA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = thb-hk-crm3.thebe.nl)(PORT = 1532))
)
(CONNECT_DATA =
(SERVICE_NAME = conv2)
)
)
CRMT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = thb-hk-crm3.thebe.nl)(PORT = 1531))
)
(CONNECT_DATA =
(SERVICE_NAME = conv)
)
)
CRMC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = thb-hk-crm2.thebe.nl)(PORT = 1524))
)
(CONNECT_DATA =
(SERVICE_NAME = testconv)
)
)
CRMM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = thb-hk-crm2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mstr)
)
)

CRST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = apps1.thebe.nl)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = crst)
)
)

CRSA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = apps03.thebe.nl)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = crsa)
)
)
CRSP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = apps03.thebe.nl)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = crs)
)
)

ICDBT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = thb-hk-crm3.thebe.nl)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = icdbt)
)
)

 

[Marco Kalter]

Can you show me the definition of this tool (executable, parameters, default path)?

 

[Makker]

I'm sorry: when delivering the information I saw that I got #connect @"#file" in the parameters field and #path in the default path.

I changed it to #connect @"#file" in the parameters field and #dir in the default path field. Now it works!

Regards,
Martien