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
Did you know?Explore Trending and Topic pages for more stories like this.
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
No comments posted yet

Your Answer:

Login to answer
324 Like 20 Dislike
Previous forums Next forums
Other forums

Structure Question - One Table or One Table Per Record Set?
I have a web app (mySQL and PHP) which allows people to create an item with up to 200 records which

PHP login form help (Done Most of It)
Hi i am having a problem, when i try logging in it is always saying "Invalid Login" im not

What's best way to get a user's Word doc converted to simple html and images?
Hi all,

I was just wondering if anybody has any experience of this.
Basically, I'm buildin

HELP with mysql_real_escape_string
I'm looking to remove apostrophes completely when someone enters lyrics but don't have a clue how to

upload image name with extension using php
hi frds..

<input id="file1" type="file" name="file[]" &a

problem with php mysql query
Hi guy's...

I'm totally lost here..because don't have any idea how to make a query for grab r

php/xmlrpc class issue
I am working on xml-rpc in php to start with.

I have a class that only has variables defined

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

Insert Failing.
Hey,
I am making a Sign up page for a website, but the insert query into the Database does not se

question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash