Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Procedure publishing with SQL*Plus ?
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
>