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

Adding delete feature to my forum
Hello I am currently trying to add a delete feature to my forum. I believe I have everything built r

php email checker
I am having alot of trouble finding info on how to do these email things. I need to do the following

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

how to load a Sys file with system load and call images?
normally you need register the module as a service with CreateService, and start the service

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

How to implement HTTP connection timeout
Hi All,I would like to implement an HTTP connection timeout.

I am working on a application wh

in php, link returns to the line
When I add a link in a php page, the link word returns to the line (as a
would do)

Examp

Sufficient protection from bad input?
I am writing a simple script to let people upload 'pages' of their own content, be it simply a few b

SAP Project Module
I have seen in the SAP Project Module,plan cost and budget are not equal and even difference is sign

Parse String
I need to parse the string below into three variables. How would I do that?

john + 10/20/2008

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