Home > Default > PL/SQL: ORA-00984: column not allowed here (emp.no)

PL/SQL: ORA-00984: column not allowed here (emp.no)

November 30Hits:0
Advertisement
I want to insert the value of a portlet form field into a table.
Any help ?
procedure afterValidation
p_block_name in varchar2,
p_object_name in varchar2,
p_instance in integer,
p_event_type in varchar2,
p_user_args in varchar2,
p_session in out nocopy PORTAL.wwa_api_module_session
is
begin
INSERT INTO PARAMS(F_SESSION,FN_1) VALUES(USERENV('SESSIONID'),EMP.NO );
end;

Answers

I want to insert the value of a portlet form field into a table.
Any help ?
procedure afterValidation
p_block_name in varchar2,
p_object_name in varchar2,
p_instance in integer,
p_event_type in varchar2,
p_user_args in varchar2,
p_session in out nocopy PORTAL.wwa_api_module_session
is
begin
INSERT INTO PARAMS(F_SESSION,FN_1) VALUES(USERENV('SESSIONID'),EMP.NO );
end;

Read other 5 answers

Tags:

Related Articles

  • PL/SQL: ORA-00984: column not allowed here (emp.no)November 30

    I want to insert the value of a portlet form field into a table. Any help ? procedure afterValidation p_block_name in varchar2, p_object_name in varchar2, p_instance in integer, p_event_type in varchar2, p_user_args in varchar2, p_session in out noco

  • PL/SQL: ORA-00984: column not allowed hereOctober 11

    I am Trying to compile this procedure, but i get error, could please anybody help me out. Thanks. SQL> create or replace procedure FOF_sport_setup( 2 v_model_cd in varchar2, -- model_cd used in many place 3 v_portfolio_name in varchar2, -- portfolio

  • Database trigger - PL/SQL: ORA-00984: column not allowed hereNovember 30

    I am trying to create a trigger that will update an employee audit table when a row is changed. Using a sequence number to assign a unique identifier to each row as it is created. Need to capture the user ID, date of the change, and the action (updat

  • ORA-00984 Column not allowed here. Please help.November 30

    Hey, I have made a table; CREATE TABLE Borrower ( BorId VARCHAR2(5) NOT NULL, BorName VARCHAR2(20), BorMaxBooks NUMBER(10), PRIMARY KEY (BorId)); I am trying to enter values into this table; INSERT INTO Borrower VALUES ( 001, "Jack Jones", 5); A

  • Help - error : ORA-00984: Column not allowed hereNovember 30

    Hi, I'm writing a simple Java program to update values into Oracle tables. But getting error - 'ORA-00984: Column not allowed here' in the line - sql2.executeUpdate(acctTabSql); There is no column name used in 'insert statement - and referred suggest

  • ORA-00984: Column not allowed here.November 30

    Hi there, I've got a little problem with the ORA-00984 error. I just begun PL/SQL, so maybe you can support me with this. I want to write a Trigger that fires every time a row in a table is changed or deleted. Trigger should write the following into

  • Eclipselink producing incorrect sql - ORA-00918: column ambiguously definedNovember 30

    We have a table with many columns .A1 .A2 .A3.... .A125 .N1 .N2 .N3... .N95 and with a simple jpql join it comes up with 2 columns that are ...AS N1150 and causing an ambiguous column error ... Does any one know of a valid workround or if this is a k

  • Passing #COLUMN_VALUE# as parameter to pl/sql function in column templateOctober 11

    Hi all, I want to color negative amounts in red in sql report using column template. I created a pl/sql function"isNegativeNum" which returns 1 or -1. create or replace function isNegativeNum(p_column_value varchar2) return number as l_dummy num

  • PL/SQL :ORA-04052 with Database linkOctober 11

    i have created a database link in my producation database as following CREATE PUBLIC DATABASE LINK <NAME> CONNECT TO <USER> IDENTIFIED BY <P/W> USING <CONNECT STRING OF TARGET DATABASE oracle version 9.0.2.8 OS : Windows 2003 EE R2 SP

  • PL/SQL: ORA-00932: inconsistent datatypes: expected UDT got NUMBEROctober 11

    Hi all, Wondering if you could assist? I'm exploring User Types and having a small problem. I'm getting the above error for a user type I have created which I'm calling in a function. Here's what my code looks like which I'm running the 'scott' schem

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.754 s.