Solved

PL/SQL

Posted on 2004-04-21
6
1,189 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
Comment Utility
It seems you haven't created the P_1 parameter...
0
 
LVL 23

Expert Comment

by:seazodiac
Comment Utility
what's PARAMETER.P_1?
0
 

Author Comment

by:achille67
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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.

Join & Write a Comment

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…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

762 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now