ERPstuff - Oracle EBS Community

As Oracle has moving toward Jdeveloper as development IDE instead of Forms/Reports and SOA is the future archecture. Therefore it is requested to create the new forms for discussion on subject tools.

Thanks

Try this , I hope this will heip you. declare vdaycnt number; vday varchar2(20); begin go_block('block3'); for vdaycnt in 1..365 loop select rtrim(to_char(to_date('01-Jan-2008')+vdaycnt,'DAY')) into vday from dual; if vday in ('SATURDAY','SUNDAY') then :sat_sun:=vday; :dat:=to_date('01-Jan-2008')+vd...

AOA, I am facing a problem with forms 6i. After making changes\modifications, when i copy .fmx file to any other computer, the changes do not reflect and LOV and Menu bar also dont respond. But when i compile .fmb file on that machine, then .fmx start working fine. Please do guide me. Thanks Niaz

AOA

I want to send a e-mail from froms with attachment using UTL_MAIL.

it is working without attachment, but when i use UTL_MAIL.SEND_ATTACH_RAW it gives ORA-29280 (Director error)

Can any one has clear example of its.

I will be thank for help


Regards


Niaz

AOA, I am using Oracle 9i, Forms/Reports 6i. I am developing <b>Visitor Information System</b> (Information of a visitor will be enterd into system on reception desks) My requirement is to take photograph to visitor on reception desk and print that picture on his visitor card. I will be thankful for...

AOA, <b>Oracle9i Enterprise Edition Release 9.2.0.1.0 </b> 1. I have <b>LONG RAW</b> field in EMP table and data has also been added. When we export database, it shows <b>EXPORTING ------EMP</b>, BUT while <b>importing EMP table is skipped</b>. 2. I want to store picture in BLOB datatype but is not ...

Asslam-o-Aliakum

I have employee pictures saved in Database Long Raw field.
I want to display these picture through <b><u>cursor </u> </b> on a <u><b>mannualy designed form.</b></u>

Regards


Muhammad Niaz Qureshi

AOA

I am working on HR System..........Waiting list of ex svc officers is mantained...........i have filter that data with following example.
parmeters:

Rank_id in ('10','11','12')
Corp_id in ('05')
app_status='WAITING'
Army_retirement_Date>'01-Jan-199')

Regards


Muhammad Niaz Qureshi

AOA

I want to call/run Seagate Crystal Report from form 6i with multiple parameters.

Any one can help me.


Muhammad Niaz Qureshi
Oracle Developer

Thanks.

I have done this by copying <b>d2kwut60.dll</b> file in system32 folder.


Muhammad Niaz Qureshi

Assalam-o-Alaikum

Admin and Mirza Sahib

I have attached D2KWUTIL.PLL file and copied all program unit in form where i want to apply this but Change icon is still not working.

<b>FRM-40734</b>-----------------appear when i run that form........

Regards

Muhammad Niaz Qureshi

AOA

Any body has idea how to change the title/icon of MDI FORM.??



Muhammad Niaz Qureshi
Oracle Developer

AOA

I have done this static values in LOV. But if there is any other possible solution please do write.



Regards

Muhammad Niaz Qureshi

Assalam-o-Alaikum

Thanks Mirza Sahib.
I have done it with xcopy command.


Muhammad Niaz Qureshi

HI I want code for copy files/folders from one location to another in Oracle Forms 6i. ie: from c:\my_folder to d:\your_folder or form //server/c$/my_folder to d:\your_folder Can any body has done so or have any idea. Muhammad Niaz Qureshi Oracle Developer