PL/SQL: ORA-00984: column not allowed here
475908Feb 16 2006 — edited Mar 11 2007I 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 name
4 v_src_acct_nbr in varchar2, -- source account number for port
5 v_src_fund_nbr in varchar2, -- source fund number
6 v_fmr_fund_nbr in varchar2, -- fidelity fund number
7 v_src_cd in varchar2, -- source code
8 v_last_mod_id in varchar2 -- your corp id
9 )
10 as
11 v_new_portf_id number(12);
12
13 begin
14
15 select max(portf_id) into v_new_portf_id from portfolios;
16
17 insert into portfolios
18 (portf_id,
19 portf_cd,
20 portf_name,
21 portf_typ_cd,
22 inception_date,
23 sub_product_cd,
24 product_cd,
25 product_line_cd,
26 bus_line_cd,
27 dly_perf_restr_ind,
28 portf_mgr_id,
29 seed_acct_nbr,
30 use_epas_ind,
31 epas_drop_perf_ind,
32 src_acct_nbr,
33 src_fund_nbr,
34 fmr_fund_nbr,
35 src_cd,
36 last_mod_id,
37 last_mod_dt)
38 values
39 (new_portf_id,
40 v_model_cd,
41 v_portfolio_name,
42 "RETAIL",
43 v_inception_date,
44 "FREE",
45 "FREE",
46 "FREE",
47 "PAS",
48 "Yes",
49 3,
50 "31635C101",
51 "N",
52 "Y",
53 v_src_acct_nbr,
54 v_src_fund_nbr,
55 v_fmr_fund_nbr,
56 v_src_cd,
57 v_last_mod_id,
58 sysdate);
59
60 end;
61 /
Warning: Procedure created with compilation errors.
SQL> show errors procedure FOF_sport_setup
Errors for PROCEDURE FOF_SPORT_SETUP:
LINE/COL ERROR
-------- ------------------------------------------------------------
17/2 PL/SQL: SQL Statement ignored
51/3 PL/SQL: ORA-00984: column not allowed here
SQL>