Forms :: Frm 41344 Ole Object Not Defined?

Oct 16, 2006

i have flash item on canvas weh nthe nw form insatance i have that erros frm 41344 ole object not defined

View 5 Replies


ADVERTISEMENT

Forms :: FRM-41344 OLE Not Defined For SCAN In Current Record

Jun 1, 2010

my problem is this that i have developed a form.fmb in 6i for images scanning direct from scanner but its generating error something like that "FRM-41344 OLE not defined for SCAN in the current record"

li have a winxp enviroment i have already downloaded and installed "IMAGING FOR WINDOW"(GLOBAL 360) but despite this its not working same error is still there .

one more thing why imgscan.ocx is not registering in winxp.

View 3 Replies View Related

PL/SQL :: Error In Modifying Object Value In Triggers Defined On Object Tables

Sep 26, 2012

While practicing with Triggers, the following error was encountered. An Object Type and an object Table are created.

create or replace
type typPerson is object
(id number,
firstname varchar2(30),
lastname varchar2(30)
[code].........

I executed the below insert statement, and I got the following error.

SQL> insert into person_obj_tab values (10,'Object1','From Trigger');
insert into person_obj_tab values (10,'Object1','From Trigger')
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 4153
Session ID: 136 Serial number: 305
[code]......

SQL> insert into person_obj_tab values (10,'Object','Original');

1 row created.Question:

1) Trigger of version 1 did not report any error during compilation, but during DML execution, hangs for sometime and gives the above error.
2) Whether direct assignment of Objects of greater size is possible inside triggers built on object Tables?
3) Suppose an object contain multiple attributes (say more than 20), then how to assign them inside a trigger?

View 1 Replies View Related

SQL & PL/SQL :: Mapping User Defined Object Types On REMOTE Databases

Dec 2, 2010

I need to transfer PL/SQL or NESTED table from LOCAL database to REMOTE.I need to be able to use that transfered table in SELECT statement.I tried:

--ON LOCAL
SELECT SYS_OP_GUID() FROM DUAL;
--966D2DFEAEEB80D6E0430A0166CB80D6
create or replace type varchar_number_oid OID '966D2DFEAEEB80D6E0430A0166CB80D6' as object (
v varchar2(10),
i number);
/
Type created
SELECT SYS_OP_GUID() FROM DUAL;
--966D2DFEAEFB80D6E0430A0166CB80D6
[code]....

I tried using PL/SQL types it worked, but then i have a problem that i can not use local collection in SQL.

View 2 Replies View Related

Precompilers, OCI & OCCI :: Retrieve Collection Of User-defined Object?

May 9, 2003

I am having a OCCI problem, I try to retrieve a collection of user-define objects.

The major steps I am using are
1. define database object

CREATE OR REPLACE TYPE my_obj_t AS OBJECT
( id number, name varchar2(10) )
CREATE OR REPLACE
TYPE my_obj_tab_t as table of my_obj_t;

2. A stored procedure return a collection as out paramerter
my_stored_procedure(obj_list out my_obj_tab_t);

3. Using OTT to generate the *.cpp and header files.

4. Register out parameter like
vector<my_obj_t> vect;
stmt->registerOutParam(1, OCCIVECTOR,
sizeof (vect),
"MY_OBJ_TAB_T");

5. stmt->execute();

6. Try to get the results by
getVector(stmt, 1, vect);

I am getting compilation error:

Could not find a match for
oracle::occi::getVector(oracle::occi::Statement*,
int, std::vector<my_obj_t, std::allocator<my_obj_t>>).

Am I doing the right things ?What steps and function should I use ?

View 1 Replies View Related

ORA-22804 Remote Operations Not Permitted On Object Tables Or User-defined Type Columns?

Jul 5, 2013

I have a two different Databases. I created a db link in DB 1 to connect to DB 2 and it is working fine when I select data from any table. but I have one table in the DB2 which has a column with user defined data type . so when I try to select this column from DB 2 by using the DB link it gives me this error :ORA-22804 remote operations not permitted on object tables or user-defined type columns.

View 1 Replies View Related

Forms :: User Defined Login Form

May 3, 2011

I have designed a Login form which takes username, password and connect string is hardcoded.I have compiled it, made an fmx file. created a shortcut to desktop. given the BIN path in shortcut.

when i want to lauch it, oracle's default login popup is shown.It can be by passed while defining username/password@string in shortcut properties but it reveals the password. every one can access it. I want to launch my own form without logging in to oracle. how can i avoid default login popup?

View 8 Replies View Related

Forms :: 10g - Debug And Check Values Of Defined Variables

Sep 22, 2010

I am currently working in form 10g and i m newbie to that technology...I want to debug my form and also check step step by values of variables which i defined.

View 1 Replies View Related

Forms :: How To Create User - Defined Search In Runtime Oracle 6i

Sep 24, 2012

Is it Possible to create User - defined Search forms in runtime oracle forms 6i . If One Having sample Forms

View 1 Replies View Related

Forms :: How To Hide / Suppress User Defined Alert Messages

Dec 19, 2011

Is it possible to hide/suppress an user defined alert message in Oracle Forms application?

View 1 Replies View Related

TimesTen In-Memory :: OracleDataReader - Object Reference Not Set To Instance Of Object

Jan 25, 2013

I have a problem with executing oracleCommand.ExecuteReader() method. Whatever I try it always returns null and it won't create OracleData reader object. I'm using ODAC 1120320_x64 for .net 4.0 and timesten112241.win64. Don't sure what to do. Debugger is showing strange thing in OracleConnection object : ConnectionState = Closed, but output of ttStatus shows connection to TimesTen data store and ExecuteNonQuery() command works just fine with or without (in or out) parameters. But when I try to execute some query with multile output such as select *, I can't get any result.

I also have a strange problem with connection.Open() When I execute Open() i throws AccessViolationException that can be handled with [Handle ProcessCorruptedStateExceptions] attribute, but connection is established after that and my application works fine until I try to instance OracleDataReader object.

Here is the code:
OracleCommand select = null;
OracleDataReader reader = null;

select = new OracleCommand(selectStmt, connection);
select.CommandType = CommandType.Text;
try
{
reader = select.ExecuteReader(); // this line throws NullReferenceException
if (reader.HasRows)
{
[code]....

Just to mention, I tried it with different queries (pl/sql, plane sql, stored procedure) and all of them works fine in SQL Developer, but not in app.

View 10 Replies View Related

Find Dependent Object Details For Any Object

Dec 24, 2012

Is there any query to find the dependent object details for any object. Like if mview is built on a table, then i should be able to find the table name with out checking code of the mview. similar way for view and functions or procedures etc...

View 5 Replies View Related

Forms :: Saving The Object Group

Dec 13, 2010

I've created Object Group which consists of (alert, parameters, visual attribute and property class). Now I want to save this Object Group.

View 3 Replies View Related

Forms :: How To Avoid (no List Elements Defined For List Item) Error

Sep 27, 2011

I am creating the Dynamic list but when i am compiling the form it gives the compilation error "No list elements defined for the list item".

I can eliminate it by entering the dummy list element but this dummy value will be displayed at form run time.

View 1 Replies View Related

Forms :: FRM-30351 / No List Elements Defined For List Item

Oct 30, 2011

DECLARE
CURSOR GRP IS
SELECT RowNum rn, Letter_Group_ID||'-'||A_Desc AName,Letter_Group_ID
FROM Hrs_Group;
BEGIN
Clear_list('Letter_Group_ID');
FOR I IN GRP LOOP
Add_List_Element('Letter_Group_ID',I.rn,I.AName,I.Letter_Group_ID);
end loop;
END;

FRM-30351: No list elements defined for list item.

List LETTER_GROUP_ID

View 4 Replies View Related

Forms :: Calling Report In Object Navigator

Feb 22, 2010

Created a report object "REPORT62" in Forms Objectnavigator

Trigger on When Button Pressed

DECLARE
rep_id REPORT_OBJECT;
rep_result VARCHAR2(200);
BEGIN
rep_id := find_report_object('REPORT62');
rep_result := RUN_REPORT_OBJECT(rep_id);
END;

Report is called in the property

Filename C:DevSuiteHome_1forms est.rdf

When button is pressed error is raised

There was a failure in the Form server during startup. This could happen due to invalid configuration.

View 5 Replies View Related

Forms :: How To Call Procedure From One To Another Object Library

Jan 29, 2013

I have one procedure "PROC_A" in LibraryA, Is it possible to call this procedure PROC_A from LibraryB.

View 1 Replies View Related

Forms :: Tree Object - Want To Use It Through MOUSE And KEYBOARD?

May 27, 2011

I created TREE object in my application main menu and I want to use it through MOUSE and KEYBOARD therefore I add WHEN-TREE-NODE-ACTIVATED trigger at my tree object

Trigger text is:
declare
htree item;
node_value VARCHAR2(100);
akt_node ftree.node;

[code]...

Problem:When I am using MOUSE and clicking on + or anyother form/report, it's opened last selected form/report or application closed but it is working fine when I am using KEYBOARD.

View 1 Replies View Related

Forms :: Export Source Code Of Object?

Jul 1, 2010

i build a form to get the source code of an object from the database and export the result into a text file but i face a problem I cannot get more than 780 line of code because i have a package with 24080 line and i have to put all this line in the text file

I attached the form

I know that the problem with the size

CM: removed unnecessary colour coding - it doesn't make it easier to read you know.

View 7 Replies View Related

Forms :: Saving Excel Files As Object In Oracle?

Feb 13, 2012

How can we save Excel file as an objectin oracle. Like we can store image file.

View 1 Replies View Related

Forms :: Oracle Builder Object Navigator Reports

Nov 16, 2011

I am using Oracle Forms Builder 6i. When you open it, in the navigator tree:

- Forms - MODULE - Reports

I want to know what is the purpose of REPORT section in the Forms Builder.

View 6 Replies View Related

Forms :: Frm-15500 Valid And Unique Object Name Must Be Entered

Feb 28, 2012

I'm trying to add a column in an existing form. I added a text item and defined it as a database item. When I tried to rename the item the message (frm-15500 valid and unique object name must be entered)appears, and therefore not able to exit the property Platte.

Is there a way I can exit the Platte and should I've first add the column to the data block and then rename in my form ?

View 1 Replies View Related

Forms :: Finger Prints In 6i (plus Rant From User) And OCX Object

Apr 8, 2008

i have a thumb reader device and i want know how it works such as

A.How to read data from serial port or usb port
b.how to save data into a oracle table or in a text file
c.How to match finger prints

View 14 Replies View Related

Forms :: Unable To Create Object For Excel 2007 / Windows 7?

Aug 11, 2010

The below Oracle Forms code works fine for Excel 2003/Windows XP/IE6 but doesn't work for Excel 2007/Windows 7/IE8.

*********************
application := Client_OLE2.CREATE_OBJ('Excel.Application');

Client_OLE2.SET_PROPERTY(application,'Visible','TRUE');

workbooks := Client_OLE2.Get_Obj_Property(application, 'Workbooks');

args1 := Client_OLE2.create_arglist;
************************

There is no error while executing the form, by debugging we found that the control skips all the above code.

I'm using Oracle forms 10.1.2.3 and jre 1.6.0_16.

View 3 Replies View Related

Forms :: Webutil EXCEL Download CLIENT_OLE2 Stops When Create Object

May 22, 2010

When Running forms on local machine I successfully download data to excel. But when I place this to server (unix), the forms stops in this line: application := Client_OLE2.create_obj('Excel.Application');

I think I have no problem with webutil setup or signing it including the jacob because another form is running on server with webutil functions loading and downloading images (pdf).

The problem is why when it comes to excel I have this issue. When I run the form and the code mentioned above is encountered, the program stops. What I have on java console are:

Loading http://59.0.0.132:7778/forms/java/frmall_jinit.jar from JAR cache
Loading http://59.0.0.132:7778/forms/java/frmwebutil.jar from JAR cache
Loading http://59.0.0.132:7778/forms/java/jacob.jar from JAR cache
proxyHost=null
proxyPort=0
connectMode=HTTP, native.
Forms Applet version is : 10.1.2.0

[code]....

View 4 Replies View Related

PL/SQL :: How To Access Type Object Variable Declared Inside Another Type Object

Mar 29, 2013

I have an Type-object typeObj1 that consists another Type-object typeObj2. this def has another Type-object typeObj3. how to access variable declared inside typeObj3. I have syntax below for each Type.

CREATE OR REPLACE TYPE typeObj1
AS OBJECT
   (
      SYSTEM_IDENTIFER                    VARCHAR2(50),
      PROCESS_TYPE                          VARCHAR2(50),
      abc                                            typeObj2
     
   )
/

[Code]...

/I have tried to access the type-object in where clause in following way

FROM TABLE(CAST(I_typeObj1 AS typeObj1)) ITTPRC,
......
Where
.......
AND (ADDKEY.ADDTN_INFO_KEY_TYP_NM IN (SELECT ADDTN_INFO_KEY_TYP_NM FROM TABLE(ITTPRC.abc)))

AND (ADTINF.ADDTN_RQST_TYP_VAL_DT  IN (SELECT ADDTN_RQST_VAL_DT FROM TABLE(     ITTPRC.def)) OR ITTPRC.def IS NULL )
AND (ADTINF.ADDTN_RQST_TYP_VAL_NUM  IN (SELECT ADDTN_RQST_VAL_NUM FROM TABLE( ITTPRC.def)) OR ITTPRC.def IS NULL )
AND (ADTINF.ADDTN_RQST_TYP_VALUE  IN (SELECT ADDTN_RQST_VALUE FROM TABLE( ITTPRC.def)) OR ITTPRC.def IS NULL )

In this way i am able to access the variable inside typeObj3. But problem is i am getting error "ORA-01427 single-row subquery returns more than one row" when i pass more that one typeObj2.

I passed the values like this in proc execution.

T_T_A_I_V  :=  typeObj3('asdasd',NULL,NULL),
                       typeObj3('String654',NULL,NULL),
                       typeObj3('abcdef',NULL,NULL));                                    
T_T_A_I_I  :=  typeObj2('CampusCode',T_T_A_I_V),
                          typeObj2('PlanNumber',T_T_A_I_V);

What i have done is removed typeObj3 from typeObj2, variables defined in typeObj3 are added in typeObj2 then i got ride of above error. is it correct

View 4 Replies View Related

Forms :: PDE-PLI011 A Tools Common Schema Table Missing From Object Store

May 26, 2011

while trying to open an exisitng Form, an Error message appears as:

PDE-PLI011 A tools common schema table is missing from the object store.

and failed to open. what's the problem ? what i have to do ? it was working fine before.

View 2 Replies View Related

Memory Max Target Is Defined As 34 GB

Jul 5, 2012

i am running 11.2.0.1 on HP-UX PA-RISC (64-bit). My Memory max target is defined as 34 GB and memory target is 32 GB on the database. The host has 256 GB physical memory. i see memory utlization is almost 90% used when seen from Grid Control on the host and wondering, what's going on? when i see into more details, i see the following 3 HP Processes consuming around 3.6 GB memory and rest very small is consumed by Oracle processes. Who's using the rest of the memory?

View 3 Replies View Related

SQL & PL/SQL :: Cursor Defined To Retrieve Row By Row

May 26, 2011

In SQL server the cursor is defined to retrieve row by row and process it. We can fetch records as FIRST, LAST, NEXT, PREVIOUS and SCROLL like that. Can we do the above in oracle. Else what is the use of cursor in Oracle. I know that it is a private area in which the records are processed.

View 6 Replies View Related

SQL & PL/SQL :: User Defined Type

Jun 19, 2012

I am trying to create a new data type but keeping getting a ORA-0902 invalid data type error. I am using the example show at:

Guess I cannot post a link until I have posted more than 5 messages so here is the link another way:

www(dot)psoug.org/reference/type.html

Specifically, all the steps work up to Create Table which fails with the error.

By work -- I mean the type gets created & the 3 select statements prior to Create Table confirm the existence of the ssn_t data type.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved