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

mysql select query problem
how can i select multiple fields from multiple table in one query like

i have table name t1 a

weird problem
last time, i did post a topic concerning why my page sometime will load as blank page when using IE.

Looking for help reading a .txt or .ini file and outputting the info.
I have a file called Info.ini and It has the following info:
Code: [General]
Online=0
I wou

Displaying Site Logo/Icon on a Title tag
really need some help out here. I want to insert a Logo/Icon just like the one close to the "PH

How to set pass login name from htaccess to php
When the user logs into my members page via htaccess, I'd like to retain the username so that I can

PHP If Else statement for breadcrumb
Hi

I am trying to use a PHP if else statement to display a breadcrumb link on wordpress

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

User registration and login
I don't know whether this is the correct forum, if not i apologise but am pretty desperate at the mo

Uploading/Downloading files stored in MySQL database
Hey all,

This problem just came up in my website and I'm having a hard time figuring out what

need to apply an if/else statement to Tim Thumb script
Not sure how to work this. I essentially want to call a variety of image sizes based on which style