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

Gantt Chart Tool
Does anyone know of a good free gantt chart creator tool

Thanks

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

Preventing SQL Injection
I have a question about SQL Injection, In some of our code we use this: view plaincopy to clipboa

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

SWF image using php?
Hello once again.

My latest en devour requires me to produce an image of a static .swf that i

check if value exists
I have googled this for a while and I am getting lots of different results. Is there a standard meth

Probably Easy, Need help with Check Boxes in PHP Code
hello,

Thanks for looking this over and helping me out. My problem is I have a online store l

do while...woes
I'm sure this is childsplay but it is stumping me, everytime i try what I think would make this work

INSERT data problem!
After having an string with apostrophes ', double quotes " or any other special characters, suc

How to make URL loads only on login
On my page, when a user login he's redirects to user_home.php. I made it also to open the chat scree

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