One insert many function calls

From: <gaop_at_my-deja.com>
Date: Wed, 22 Sep 1999 21:14:07 GMT
Message-ID: <7sbgqk$t6f$1@nnrp1.deja.com>

I have a function which creates an instance of object type. When I use this function to generate an instance for an insert, the function is called many time. The following is a tes I have run. The function TEST5 gets called 8 time for one row inserted.

Any ideas?

Regards,

Gao Peng

---

SQL>
SQL> CREATE OR REPLACE FUNCTION TEST5 RETURN MDSYS.SDO_GEOMETRY AS   2 BEGIN

  3      dbms_output.put_line('TEST5');
  4      RETURN MDSYS.SDO_GEOMETRY(0, 0, null, null, null);

  5 END;
  6 /

Function created.

SQL> CREATE TABLE MYGEOM (gid number, geom MDSYS.SDO_GEOMETRY);

Table created.

SQL> INSERT INTO MYGEOM values (111, TEST5()); makeOne: [B_at_2862355c 109 SYS.ODCIINDEXINFO class oracle.sql.STRUCT makeOne returns: class oracle.sql.STRUCT TEST5
TEST5
TEST5
TEST5
TEST5
TEST5
TEST5
TEST5 1 row created.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 22 1999 - 16:14:07 CDT