how to fix runtime report oracle developer 6i for windows 64 bit

Replace nn60.dll and nnb60.dll on bin directory developer 6i with patch 3 (attachment)

explanation from here
http://halimdba.blogspot.com/2009/05/oracle-forms-or-reports-6i-in-windows.html

multiply:nn60.zip
multiply:nnb60.zip

ziddu:nn60.zip
ziddu:nnb60.zip

Keypress on Oracle Forms 6i

Oracle Forms is a block mode data handling system. It does not do “character by character”. Use a Java thingy. There are examples, and links to examples, on the Oracle Forms web site.

David

 

 

For web-based apps you can use a pjc

http://sheikyerbouti.developpez.com/forms-pjc-bean/pages/keystrokeinterceptor.htm

 

forms60.vrf(78): OS_ERROR while getting value Path

links : http://forums.oracle.com/forums/thread.jspa?threadID=650537

Although this Q is not so “hot” anymore, several days before I’ve ran into same problem.
By searching the google for “forms60.vrf” I’ve found just this post with question and no good answers.
Since I’ve found the solution, I think it’s OK to share it with others.
Of course that Forms6i is not something of big interest these days, but there are still some of us that need to install Forms6i Developer for various reasons (maintaining old applications, preparations for migration to other technology, etc.)
I’ve tried installation with disabled anti virus (to tryout already suggested hint) , it didn’twork for me – installation failed with the same error.

OK, here is what I’ve done.

I’ve modified my PATH environment variable to “shorter” string, since I remember similar issues with several “older”

Happy 2011 to everyone. I have been using TEXT_IO.FOPEN (‘LPT1′, ‘w’) in oracle form to sent text to LPT port printer without having any problem but nowadays most PC come with USB port and hence my programs failed to execute such command. Does anyone know or has any idea how to use TEXT_IO.FOPEN to sent text to USB printer direct?

Thank you and best regards.

TH

Hi TH Cheng

If you are using a new computer with an existing printer that still has a parallel connector, you could buy a USB to Centronics cable. When connected, it shows up as a parallel port in the hardware list.

Contoh Delete_List_Element

Jika List KD_JK_WKT1 mempunyai element list :

1. ‘Tahun’,'T’
2. ‘Bulan’,'B’
3. ‘Hari’,'H’
4. null

Kemudian di delete Hari secara manual, menjadi :

1. ‘Tahun’,'T’
2. ‘Bulan’,'B’
3. null
4. null

Clear_List(‘BLK_TEMP.KD_JK_WKT1′);

DELETE_LIST_ELEMENT(‘BLK_TEMP.KD_JK_WKT1′,2);

ADD_LIST_ELEMENT(‘BLK_TEMP.KD_JK_WKT1′, 1, ‘Tahun’, ‘T’);

Hasilnya adalah :

1. ‘Tahun’,'T’
2. ‘Bulan’,'B’

Tutorial forms reports developer 6i

Download via wordpress forms_reports_update 700 KB

Download via Ziddu forms_reports_update 700 KB

Example Data Block Forms to Excel

PROCEDURE pr_Forms_to_Excel(p_block_name IN VARCHAR2 DEFAULT NAME_IN(‘system.current_block’)) IS
– Declare the OLE objects
application OLE2.OBJ_TYPE;
workbooks OLE2.OBJ_TYPE;
workbook OLE2.OBJ_TYPE;
worksheets OLE2.OBJ_TYPE;
worksheet OLE2.OBJ_TYPE;
cell OLE2.OBJ_TYPE;
range OLE2.OBJ_TYPE;
range_col OLE2.OBJ_TYPE;
– Declare handles to OLE argument lists
args OLE2.LIST_TYPE;
– Declare form and block items
form_name VARCHAR2(100);
f_block VARCHAR2(100);
l_block VARCHAR2(100);
f_item VARCHAR2(100);
l_item VARCHAR2(100);
cur_block VARCHAR2(100) := NAME_IN(‘system.current_block’);
cur_item VARCHAR2(100) := NAME_IN(‘system.current_item’);
cur_record VARCHAR2(100) := NAME_IN(‘system.cursor_record’);
item_name VARCHAR2(100);
baslik VARCHAR2(100);
row_n NUMBER;
col_n NUMBER;
filename VARCHAR2(100);

Script Import dari Excel ke Oracle (Oracle Form6i)

–example
PROCEDURE ddepack IS
appid PLS_INTEGER;
convid PLS_INTEGER;
docid PLS_INTEGER;
conv_established BOOLEAN := FALSE;
buffer1 Varchar2(8);
buffer2 Varchar2(15);
buffer3 Varchar2(10);
buffer4 Varchar2(100);
buffer5 Varchar2(200);
buffer6 Varchar2(200);
buffer7 Varchar2(200);
buffer8 Varchar2(8);
buffer9 Varchar2(8);
buffer10 Varchar2(20);
buffer11 Varchar2(8);
buffer12 Varchar2(8);
DNO VARCHAR2(14);
Col1 Varchar2(8);
Col2 Varchar2(15);
Col3 Varchar2(10);
Col4 Varchar2(100);
Col5 Varchar2(200);
Col6 Varchar2(200);
Col7 Varchar2(200);
Col8 Varchar2(8);
Col9 Varchar2(8);
Col10 Varchar2(20);
Col11 Varchar2(8);
Col12 Varchar2(8);