Views and PL/SQL, Problem max. 2000 Chars for a Row

Hello,

is it possible to create a view, which gets additional rows out of a package/procedure/function?
for example a function returns a table which i use in a view?

I tried something like this

    SELECT t.key1, t.key2, katalog.text( t.key1, t.key2) text

        FROM table t;

that works with one row, but my problem is, that this row has mor than 2000 chars and
I'm restricted to 2000 Chars because of Oracle 7.3.4 limitations in views. So I must split the text-field and working with to rows and viewed as

    SUBSTR( katalog.text( ...), 1, 2000) text1,     SUBSTR( katalog.text( ...), 2001, 4000) text2 does not work.

So I want to make something like

    SELECT * FROM katalog.text( ...);

I must make it as a view!
Thanks for help,

Dirk Grabenhorst
mailto:dGrabenhorst_at_integrata.de Received on Thu Nov 09 2000 - 11:39:04 CST