Oracle directory form 6i

HOW I CAN USE FORM 6I FOR STORE AND Retriev  A FILE IN DATABASE BY  ORACLE DIRECTORY ?

KERMANI35 pointsBadges:

Error(31,19): PLS-00103: Encountered the symbol “INTO” when expecting one of the following

I got this error while compiling a select stm and it s my pckg body however package parameter hav OUT as well IN .. Error(31,19): PLS-00103: Encountered the symbol "INTO" when expecting one of the following: . ( , % from The symbol "from was inserted before "INTO" to continue. Anbody able to help...

Inprise610 pointsBadges:

iSQLPlus creating packages with multiple procedures in it

Hi, I am a bit stuck i need to create a package which has a number of different procedures in it. The procedures work on their own however whenever i try to put them into a package they then don't work and i get the error package created with complication errors, however when i type show errors...

Cazza8855 pointsBadges:

ORA106500:WHEN-BUTTON-PRESSED raised unhandled exception. … i want to open ms word file when button pressed trigger

Dear All i am using oracle 6i and oracle 9i database i want to open word file when pressed button in form but there is no error during compilation error at runtime showing below code wrote in WNBP trigger: declare AppID PLS_INTEGER; begin AppID := DDE.App_Begin('C:ProgramDataMicrosoftwindowsstart...

9492587845 pointsBadges:

Display GIS maps on Oracle forms

I want to integrate the oracle form with GIS aplications. how can i do can u please help me on this

Hadgilkar25 pointsBadges:

Default Types in Oracle Parameter Screen

I am adding my default parameters to my stage. In the default type drop down box I see Constant, Current Date, Current Time, Field, Profile, SQL Statement and Segment. I know what most of them mean but have questions on Field, Profile and Segment. I have tried searching the web for answers but came...

Petpat12370 pointsBadges:

Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following

I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol "OUT" when expecting one of the following: := . ) , @ % default character The symbol "," was substituted...

Inprise610 pointsBadges:

Oracle Reports Builder

Hi, i have one query plz help me on the same.... I am creating the report in oracle report builder 6i,  i made every thing but i stuck on one problem. it is i used group by command in sql query. i got the total of one column. but in that column there are no. of same customer name in a month which...

Ss66015 pointsBadges:

Can i use two parameter in oracle report

i want to make a report with two parameter when user select user name in one parametr other show names of all users and user select one name ane detail of that user is shown in report.or if user select any other field other parametr show data of that selected column to selected by the user to...

Zaraiqbal5 pointsBadges:

How to call Microsoft Excel from Oracle Reports/Forms 6i

how to call excel from oracle report/forms 6i plz tell me the step by step process how can we do it my e-mailid is lightmobeen@yahoo.com if any one know the process plz send me mail sonsist of code,me very thankful to u for this

Exporacle20 pointsBadges:

How does oracle avoid dead lock when I create an index on the foreign key column?

How does oracle avoid dead lock when we create an idex on the foreign Key column ? Found many experts say this, but i never really found what is the logic behind this. So any replies provided are appreciated . thanks in advance gangadhar

Gangadhar2610 pointsBadges:

Installing Oracle 9i and Developer 6i in home PC

Dear Friends My I want to install oracle in my home PC, so that I can work at home, so which oracle version, and developer that can be installed in the same machine Please give the installation details Best regards Jamil Alshaibani

MAY05659292714145 pointsBadges:

UPK Developer 3.5.1

When I click on the Save As the drive is just / Where is that pointing to? Can I change the path somehow?

UPKNewbee25 pointsBadges:

Oracle Help?What is the DB dependencies related to object sequencing for DB builds

What is the DB dependencies related to object sequencing for DB builds?

SpockII5 pointsBadges:

Oracle-developers

WHILE ASSIGNING A VALUE TO PROCESSED_TIME=:NEW.JMS_TIMESTAMP-:NEW.INS_TIME (All are timestamp type ) how to subtract that one.  CREATE OR REPLACE TRIGGER SAUUSER.TRG_MSGES_STATISTICS AFTER UPDATE OR UPDATE ON SAUUSER.TSAU_PRE_MSGES REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE BEGIN IF...

RizwanSharief30 pointsBadges:

ERROR -HTTP Listner is not running on RAHULDEOLE.rahul at port 8888.PLEASE STAR THE LISTENER OR CHECK YOUR UNTIME PROGRAMS

Hi Friends, I have an error while running Oracle Forms 10 - HTTP Listner is not running on RAHULDEOLE.rahul at port 8888.Please start the listner or check your runtime program? Help will be appericable,it will saves time. RAHUL DEOLE

RAHULDEOLE75 pointsBadges:

Database auditing

Hi everybody? I do have a shema named PRACTICE with its own table named EMPLOYEES. The table has fields: empid,fname,sex and age. Their data types are varchar2,varchar2,varchar2 and number respectively. The fields also held values LA,Lensa,F and 21 respectively. Being on the sys schema, I defined a...

Girma30 pointsBadges:

Developer 9i AS icon’s item

when i create icon's item it's not dispayed in fmb files nor fmx files. any one can help me??? 10x

FormsBuilderOracle10 pointsBadges:

db developer info

how can i get started to be a db developer?  

Databasedeveloperandadminsa20 pointsBadges:

Basic Oracle question

This might sound a little wierd, but I am a non-techie. So Apologies first for posting such basic questions here. I would like to know how are certain Oracle Applications or technology solutions developed? In the sense, what is the language used to develop E Business Suite. Or what was the language...

Prady5 pointsBadges: