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

Sharing PHP Sessions Across Domains
I am in the process of writing a script to share a php session across various domains I have.
The

PHP MySQL Return Results Issue
Hi guys,

I'm running joomla and made a module which is using ajax.
Basically i just have a

displaying email without attracting a ton of spam
Hello,

this is maybe the wrong place to ask.
How would you display an email address on a w

Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret

Pipe email to PHP - get mail adress from MySQL - send?
Hi all,

this is the challenge:

1) Our faculty at the college where I'm employed includ

Image loading
Hi Developers,

I'm trying to display an image from images/image.gif getting the url from mysq

Creating a db with a query
Hello everyone.
I'm having troubles creating a db with a query.
I'm reading a book called PHP

Calender Not Opening
The following code is not loading the javascript calender in another window. It's not doing anything

if php cookie set, show code...
Hi all.. I need to figure out this little snippet right quick.. seems like it should be easy enough

Different actions for different parts of a string
<?php
function dosomething($string, $else = '') {
if (empty($else))
$string