File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes sql file problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "sql file problem" Watch "sql file problem" New topic

sql file problem

arjun rampal
Ranch Hand

Joined: Jul 08, 2005
Posts: 125
Hi I have this sql file
1)what is this par here

2)it is giving syntax error (probabaly ; at end thats y)
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}}
{\*\generator Msftedit;}\viewkind4\uc1\pard\f0\fs20 CREATE OR ALTER
TABLE user \par
\tab regi_hu_g_code char(11) NOT NULL,\par
\tab tot_expe number(9) DEFAULT 0,\par
\tab tong number(9) DEFAULT 0,\par
\tab tol_expected number(9) DEFAULT 0,\par
\tab perc_acccy number(9,2) DEFAULT 0,\par
\tab created_by varchar2(8) NOT NULL\par
\tab created_time timestamp NOT NULL\par
\tab upf varchar2(8) NOT NULL\par
\tab up timestamp NOT NULL\par
Srinivasa Raghavan
Ranch Hand

Joined: Sep 28, 2004
Posts: 1228
Did you edit & save the sql file in wordpad ?
You see the extra characters & formatting stuffs because the editor you used added that to the sql file & oracle cannot understand it. So open a simple text editor & create the sql like

1. Open the sql in wordpad
2. Create a new document in notepad.
3. copy the contents of the sql opened in word pad & paste it in notepad
4. Save & Execute the new sql created in notepad.
[ September 14, 2006: Message edited by: Srinivasa Raghavan ]

Thanks & regards, Srini
MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: sql file problem
It's not a secret anymore!