Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

PL/SQL

Posted on 2004-04-21
6
Medium Priority
?
1,198 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 11

Accepted Solution

by:
pennnn earned 360 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

704 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