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 -> Procedure publishing with SQL*Plus ?

Procedure publishing with SQL*Plus ?

From: Mario Bucsics <mario.bucsicsNOgjSPAM_at_siemens.at>
Date: Tue, 17 Aug 1999 04:08:54 -0700
Message-ID: <11f733ec.b6a7f935@usw-ex0107-056.remarq.com>


Hello

Try to type an "/" after the "create function ..."

 Regards

 Mario Bucsics
In article <37B91A69.C5D8A6B5_at_dream.club-internet.fr>, smanux_at_dream.club-internet.fr wrote:
>Hello,
>
>I wonder if it is possible to publish a procedure with
SQL*Plus. Each
>time i type something like :
>
>CREATE OR REPLACE FUNCTION hello() RETURN NUMBER AS
LANGAGE JAVA ...
>
>SQL*Plus returns a prompt, as if i forgot the final ';'
>
>I tried to put the declaration in a SQL script, but the
result is the
>same.
>
>Hence i have to publish with a query via JDBC... not very
efficient :(
>
>
>
>Emmanuel BOURG
>

Received on Tue Aug 17 1999 - 06:08:54 CDT

Original text of this message

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