This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "sql file problem" Watch "sql file problem" New topic
Author

sql file problem

arjun rampal
Ranch Hand

Joined: Jul 08, 2005
Posts: 125
Hi I have this sql file
problems
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
5.41.15.1507;}\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
)
\par
\par
\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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sql file problem
 
Similar Threads
Help. Problem inserting Clob into Oracle 9i
Problem to display clob data
How to get a Table Schema from oracle database to Java Programs...?
Regex - Java or Perl
Performence issue:Write query directly in session bean or call storted procedure