Re: Need help with SQL Worksheet

From: <nasof_at_hotmail.com>
Date: Wed, 22 Jul 1998 13:08:06 GMT
Message-ID: <6p4o7m$don$1@nnrp1.dejanews.com>

Actually, you are right. SQLWorksheet does not recognize the END of a proc or

function and keeps on processing it into the next one.	I usually have to
break them out into sep. runs.	Alternately you could use SQL*PLUS or SVRMGR

to compile these. SQLWorksheet is nice, but it lacks alot of the functionality of SQL*PLUS (column fomatting, etc..)

Let me know if you find a way around this...

-Frank

In article <35b5a409.0_at_204.239.181.11>,   "Eric Jodoin" <ejodoin_at_inetex.com> wrote:
> Hi,
>
> I have the following code in a SQL file. If I open it and try to run it I
> get:
>
> MGR-00073: Warning: FUNCTION .s_useraccessdm created with compilation
> errors.
>
> It looks like the Create Function and Create trigger mix together instead of
> being 2 independent command.
>
> I know I have to be missing something between those 2 but I look through all
> my books and I just can't figure it out. Here is the code i used:
>
> /* My Function */
> CREATE OR REPLACE FUNCTION "S_USERACCESSDM".NEWDEPID
> RETURN INTEGER IS
> NEW_ID INTEGER ;
> BEGIN
> Select DEPTID_SEQ.nextval into NEW_ID from dual ;
> RETURN(NEW_ID) ;
> END ;
>
> /* My Trigger */
> CREATE OR REPLACE TRIGGER "S_USERACCESSDM".Department_Bit
> BEFORE INSERT ON "S_USERACCESSDM"."DEPARTMENT"
> FOR EACH ROW
> BEGIN
> IF (:new.DEPTID IS NULL) THEN
> select DEPTID_SEQ.nextval
> into :new.DEPTID
> from Dual;
> END IF;
> END ;
>
> Thanks for your help.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 22 1998 - 08:08:06 CDT