oracleforms

create a folder

Hi there I wanna know how I can create a folder via Oracle form Builder? is it possible? I mean I wanna create a folder dynamically and after that open it by Internet explorer to customer that customer easily copy his files. I use oracle 6i. ...

how I can change the oracle form builder color polette

Hi there I used oracle 6i in my project, I wanna use more color in my palette but I cant. Would you help me? I already try to go Tools->Profermence->color mode => change to editable but my problem still exist,I cant customize the costume color in my palette. also I try to all color palette to oracle form builder but I don't have any ...

Get handle from "Oracle Developer Forums Runtime" appications...

Dear all... I want to get textbox handle from "Oracle Developer Forums Runtime" appications to read it's text with VB.NET or C# But cannot!!!! Please help... ...

what's ur idea about this two way for creat a folder in oracle

According to my last question about how to create folder here I find some codes that s.b before write it! looking : (sorry for limitation i cant put codes here) they try to Create a bat file,by oracle outfile text_IO,file_type then they write these statement! body_of_file = 'Net use x: \\address' body_of_file += 'md' || filename body_of...

how I can read a SEQUENCE and write it in text item?

Please help me!I dont know why i cant solve this simple problem. I wanna read my sequence that I made it in my database and add it to my text Item. any idea?(with code plz) right know I write a cursor and call my sequence by a select from it but i dont know what should I do after it :( ...

how I can get text of selected item in list item in oracle forms?

Hi List item involved List element and list item value. my list item value is different from their text I want to know how I can get the selected item text. (it same az combo box,i need the text of selected item) plz help me. ...

problem in using system.form_status

Dear friends I try to use system.form_status state,but when i check it after I change some texts or my list item,there is no changes in system.form_status ,I just receive "query" message but I must receive "changed" message. So how I can solve my problem?has it any precondition? ...

how check radio button status in oracle form

Hi there I like to control a radio button in my oracle form. please help me how I can return its value please. ...

oracle forms 10g. Deploy on customer site in seperate OC4J instance

I have an Oracle Forms 10g (10.1.2.3) application consisting of a set of .fmx, plx and jar files. I know how to configure the configuration files on an OAS to get things running. However, at one of our customer sites I saw that they have every forms application running in it's own OC4J instance. How is this done? How do I "package" my ap...

SQL*Plus 8.0600 crashes at the trial of connect to Oracle 10g (10.2040)

Background: Oracle Forms - DB migration; 6i to 10g Hi everyone! Customer situation: We want to attemp a DB connection with SQL*Plus 8 to a Oracle 10g DB (standard installation). Unfortunately SQL*Plus always crashes without any error message. We tried the same scenario with our systems - there was no problem. Now we are confused. W...

Error FRM-30113

I use Oracle Form Builder 6i. Suddenly I receive 3 errors that I can't handle: Error Frm-30113: block must have non-query-only database item.block capa_problems. FRM-30362 Initialize value does not match available list elements. list v_impact_proc_area Item : v_impact_proc_area Block : search_block Form: problem_review_app...

how to read data blocks and store them in database?

Hi there I have problem in reading a data block in oracle form builder. I have one data block that some of their fields are come from database but there is 2 (columns)field that i need to read them manually and store them on the database(we have several row!),please help me how I can read each line and insert them on database. I use ora...

Migrating oracle 6i to 10g web performance problems

Hello We have recently migrated Oracle 6i forms with a native runtime to 10g to work with web and java. It works but with huge performance problems. For example, in the server which is running red hat, switching between two screens in the web version 10g uses 15% cpu per client!!! This is crazy and must be an error somewhere, because we...

Saving a report to a file on a client PC?

Friends, I would be grateful for a quick sanity check! When calling Oracle Reports 10g from Oracle Forms 10g, is it possible to run an Oracle Report and save it on the users PC to a specified directory? (I know that if an Oracle Report is run in such a format as PDF the user can save the report to x location). To call the Oracle repo...

Advice for a UI migration from Oracle Forms to JSP

Hi there! I'm starting a new project and would like some advice. The purpose is to migrate the front-end of a web application developed with Oracle in the back-end (version 9) and Oracle Forms 6.0 in the front-end to JSP. The layout must be the same and it's going to be developed also Web Services in the future. What advices and/or r...

How do I use the APP_MULTI package to support multi-selection in my Oracle Form?

Oracle provides the APP_MULTI package (found in the APPCORE library) to support multi-selection of records in Oracle Forms. What must I do to my form in order to take advantage of this functionality? For example: Which triggers must I implement? Which APP_MULTI methods should I call and when? ...

problem in update text item...

I Have problem in update one of my datablock textitem. the problem will raise up because I use where condition for my datablock,and after I load the data block, I try to get new value to my text item,but after I put value there is no change... I dont know how I can change a text item database value when my block has where condition.(th...

Oracle Forms - Display message blocks rest of the code execution or message doesn't show

Hi! I'm trying to show a message on a form without success. What I'm doing is: When a new line is clicked, I use the WHEN-NEW-RECORD-INSTANCE to do some verifications and some enabling/disabling on the form and showing up the message. The problem is sometimes it does the enabling/disabling but not the message, then I click another line ...

oversubscribed literal/length tree error while creating database

While running database configuration assistant(oracle 9i) I get error oversubscribed literal/length tree.Please help me out. ...

cursor in forms 6i

I am working on form6i and using case expression in cursor.But the following code is not compiling Is Forms 6i not support the case expression in cursor or any method to write case expression in forms ...