If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > newbi: struggling with syntax

Reply
 
LinkBack Thread Tools Display Modes
  #16 (permalink)  
Old 02-04-10, 11:29
anacedent anacedent is offline
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,151
not finding x.sql
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Reply With Quote
  #17 (permalink)  
Old 02-04-10, 11:37
davisb davisb is offline
Registered User
 
Join Date: Feb 2010
Posts: 12
SPOOL x.prt

W:\banner\dev\sql>sqlplus frscvt/susana65@fintest @x.sql brenda carmen

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 4 10:35:00 2010

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

var1 = brenda
var2 = carmen
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SPOOL \afs\uis.njit.edu\erp\user\finsvc\banner\dev\repor ts\x.prt;

W:\banner\dev\sql>sqlplus frscvt/susana65@fintest @x.sql brenda carmen

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 4 10:35:38 2010

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SP2-0606: Cannot create SPOOL file "\afs\uis.njit.edu\erp\user\finsvc\banner\dev\repo rts\x.prt"
var1 = brenda
var2 = carmen
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Reply With Quote
  #18 (permalink)  
Old 02-04-10, 11:39
davisb davisb is offline
Registered User
 
Join Date: Feb 2010
Posts: 12
There is no space in reports ... typo
Reply With Quote
  #19 (permalink)  
Old 02-04-10, 11:46
anacedent anacedent is offline
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,151
>SP2-0606: Cannot create SPOOL file "\afs\uis.njit.edu\erp\user\finsvc\banner\dev\ repo rts\x.prt"
Talk to local system administrator about OS file permissions.

This issue has NOTHING to do with Oracle.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On