AUTONUMBER PROBLEM

Posted on 16th Feb 2014 07:03 pm by admin

Hello Everyone,

My name is Jones and i am new to this forum and to oracle. I am using oracle 9i. the below mentioned is my problem.
SQL> CREATE OR REPLACE TRIGGER PETTY_CASH_trggg
2 BEFORE INSERT ON PETTY_CASH
3 REFERENCING NEW AS NEW OLD AS OLD
4 FOR EACH ROW
5 BEGIN
6 select
7 se_petty_cash .nextval
8 into
9 :NEW.ID
10 from
11 dual;
12 END;
13 /
BEFORE INSERT ON PETTY_CASH
*
ERROR at line 2:
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-320: the declaration of the type of this expression is
incomplete or malformed
Here "petty_cash" is my table name and i have no idea why the error is coming. It might be a simple question but please do help me

Your Answer:

Login to answer

Other forums

LOOPing Problem
Hello All!

The following code loops through the data and displays the data accordingly. My p

Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added

Warehouse Management
Hi,

On our system, we have two storage locations ( A and B ) where A is the main factory

Can you help please? Php file
I have to write this php file to allow users to register their nicknames on nickserv

For an I

void* and sizeof()
Hi,

Using void* and sizeof is it possible to get the value of the object ?

I understan

WS-Security PL/SQL Forms
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - P

Help on code output
My CODE:

Code: [Select] echo "<phone>".$line["phone"].&qu

Hom to make one url to open together with another url
I have a chat, which i want to be opened, as soon as the users login to the site. As it is now, when

Final year project, please point me in the right direction
hi there for my final year project I'm aiming to build a php script shell to use as an expert system

need help in creating captcha
hi i have a problem creating captcha system. i create some basic script for image displaying but it