PL/SQL

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;
achille67Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
pennnnConnect With a Mentor Commented:
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
 
pennnnCommented:
It seems you haven't created the P_1 parameter...
0
 
seazodiacCommented:
what's PARAMETER.P_1?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
achille67Author Commented:
PARAMETER.P_1 is  a built in variable so i don't need to create it
0
 
achille67Author Commented:
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
 
pennnnCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.