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

Home -> Community -> Usenet -> c.d.o.server -> Compiling pl/sql in sqlplus with an @ char within the code?

Compiling pl/sql in sqlplus with an @ char within the code?

From: Jeremy <jeremy0505_at_gmail.com>
Date: Thu, 8 Jun 2006 12:36:36 +0100
Message-ID: <MPG.1ef21c12f4605f0c98a200@news.individual.net>

I'm sure there's a simple answer to this one. The following code appears within a package body:

  htp.p('
<style type="text/css" media="screen">
  @import "incl/css/layout.css";
</style>

');

When I compile the package body in sqlplus I get the folowing:

12:24:43 SQL> @ic_util.pkb
SP2-0310: unable to open file "import.sql"

Package body created.

Elapsed: 00:00:00.01
No errors.
12:24:45 SQL> Now I can see that sqlplus wants to run a .sql file called import.sql - is there a SET option to avoid this? I can see that joining th eline to the preceding one might avoid this problem but is there another way around it?

-- 
jeremy

We use Oracle 9iR2 on Solaris 8 with the Oracle HTTP Server and 
mod_plsql
Received on Thu Jun 08 2006 - 06:36:36 CDT

Original text of this message

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