473,320 Members | 1,955 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

how to loop in oracle forms

Hi,

Question..

What syntax can I use if I want to loop in oracle forms? My problem is I want to insert mulitple records in a multirecord block. This is what I did and it seems like its not working. Please help!
[PHP]PROCEDURE P_EDIT_PO IS
CURSOR c_edit_podetail IS
SELECT rpi.rec_no,
rpi.pack_ind,
rpi.comp_ind,
rpi.item,
rpi.item_parent,
rpi.item_desc,
rpi.vpn,
rpi.dept,
rpi.class
FROM ros_poe_items rpi,
ros_poe_entry roe
WHERE rpi.order_no = :B_ros_poe_entry.order_no
AND roe.order_no = rpi.order_no;
Go_Block('B_ros_poe_items');
Clear_Block(No_Validate);
First_Record;
for REC in c_edit_podetail LOOP
fetch c_edit_podetail into :B_ros_poe_items.rec_no,
:B_ros_poe_items.pack_ind,
:B_ros_poe_items.comp_ind,
:B_ros_poe_items.item,
:B_ros_poe_items.item_parent,
:B_ros_poe_items.item_desc,
:B_Ros_poe_items.vpn,
:B_ros_poe_items.dept,
:B_ros_poe_items.class;
Next_Record;
EXIT WHEN c_edit_podetail%NOTFOUND;
end LOOP;[/PHP]

Can anyone help me? this is really an urgent question.

thanks
Oct 12 '08 #1
1 10631
amitpatel66
2,367 Expert 2GB
You are trying to call another block after your select query. Could you please let us know what you are trying to do exactly?
Oct 18 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Kaix | last post by:
Hello, is there a possibility to control oracle forms form a external application. I like to push a value in a text field in a oracle forms app and "press" a button in this form. Maybe i can...
1
by: MEG | last post by:
Hi, I am trying to do some authentification in a form and have run into a problem. The user types the usename/password into a couple of fields and presses the login button. The button trigger...
2
by: Azhar Bilgrami | last post by:
Hi: I want to Migrate Oracle form 3 to Oracle forms 6i, but I couldnt find that software on Oracle Website, can u please Help me?. Take care of ure self. Azhar
1
by: Chris | last post by:
Our company developed the last couple of years a development tool: using this tool we configure and program (using SQL, and Java-Script) very, very easy an application. The output of the effort is...
2
by: Thomas Kindermann | last post by:
Hello everyone, I'm an oracle database adminstrator and I search some information about possibilities to create easy forms for data input (for example for test data). My Oracle release is now...
1
by: tristant | last post by:
Hi all I need to make decision on which development tool to use: Oracle Forms or Visual Studio .Net. We run Oracle 9i on AIX. And we will develope database application. If use .NET we will use...
0
by: anuj13singhal | last post by:
Hi, I am trying to open a word document on the client machine. the document is present on the oracle application server (on windows). For that I have created a java class file wordbean.class....
5
by: paulnamroud | last post by:
Hi all, We have an application written with Oracle Forms 5.0 and report builder 3.05. We are using Oracle 8i as a database. We have around 50 forms and 10 reports. I'm in a process of...
1
by: Samarjit | last post by:
Hi, I just want to know whether Oracle forms 11g supports other databases like DB2, SQL Server etc. Also does Oracle forms 11g supports Oracle database 9i or 10g apart from 11g?
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.