Re: Spatial Cartidge - is a bug?

A copy of this was sent to "jst" <jst_at_pobox.sk> (if that email address didn't require changing) On Mon, 6 Sep 1999 18:17:31 +0200, you wrote:

>After installing Spatial Cartridge at Oracle 8.05 (Win NT) and executing all
>necessaries scripts as MDSYS user (CATMD.SQL, SDOWIN.SQL, PRVTWIN.PLB) there
>are some undefinied functions.
>For example, the function SDO_WINDOW.BUILD_WINDOW is undefinied, this error
>message is displayed:
>
>execute mdsys.SDO_WINDOW.BUILD_WINDOW('mdsys', 'example', 1, 10, 100, 100,
>110,100,100,130) ;
>
>ORA-06550: line 2, column 2:
>PLS-00221: 'BUILD_WINDOW' is not a procedure or is undefined

                           ^^^^^^^^^^^^^^^^^^

it is not a procedure. try this:

SQL> set serveroutput on
SQL> exec dbms_output.put_line( mdsys.SDO_WINDOW.BUILD_WINDOW('mdsys','example', 1, 10, 100, 100,110,100,100,130) )

that'll print out the integer build_window returns.

>ORA-06550: line 2, column 2:
>PL/SQL: Statement ignored
>
>But the function SDO_WINDOW.CLEAN_WINDOW () which is created by the same
>script is running correctly.
>
>Greatly appreciate for any comment or advise.
>
>Jan
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Sep 06 1999 - 12:35:06 CDT