Solved

PL/SQL

Posted on 2004-04-21
6
1,190 Views
Last Modified: 2006-11-17
What  is syntaxtically wrong with this code? I am having the following error:

Error 49 at line 4, column 4
bad bind variable 'PARAMETER.P_1'

THE CODE:
=======
declare
v_where varchar2(100);
begin
IF :PARAMETER.P_1 IS NOT NULL THEN
v_where := :PARAMETER.P_1;
set_block_property('student', default_where, v_where);
execute_query;
--
set_block_property('student', default_where, '');
go_block('enrollment');
end if;
end;
0
Comment
Question by:achille67
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:pennnn
ID: 10881797
It seems you haven't created the P_1 parameter...
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 10881875
what's PARAMETER.P_1?
0
 

Author Comment

by:achille67
ID: 10881903
PARAMETER.P_1 is  a built in variable so i don't need to create it
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 11

Accepted Solution

by:
pennnn earned 120 total points
ID: 10881920
You need to create a Form Parameter named P_1 in order to be able to refer to it in the code. It is not built-in. You have to create it hte way you create a block, canvas, etc.
0
 

Author Comment

by:achille67
ID: 10882099
Thanks pennn
Now i having the following error when trying to compile the form
do u know why?

Block: STUDENT
Form: ENROLL_INFO
FRM-30085: Unable to adjust form for output.
0
 
LVL 11

Expert Comment

by:pennnn
ID: 10882573
The most common case for that error is when you already have the form running, so it can't generate it again, because the fmx is being used... The message is a bit misleading... :-)
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
select only modified column name  based on the status 15 55
File generation using utl_file 4 53
PL SQL Search Across Columns 4 35
Oracle - SQL Query with Function 3 35
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question