Using rowid in a html anchor / select statement

From: Bill Tierney <wtierney_at_stanford.edu>
Date: 1996/09/15
Message-ID: <323CAD61.263D_at_stanford.edu>#1/1

I'm using webserver / pl/sql to generate a page that will have a brief record of
a search result. This search result will (hopefully) have a last column that will be a link to the full record whicj I'm hoping to retrieve using rowid....

The error I'm getting is:
SQL> show errors
Errors for PACKAGE BODY HWSHOW:

LINE/COL ERROR

---

---

40/3 PL/SQL: Statement ignored
42/53 PLS-00204: function or pseudo-column 'ROWID' may be used inside a

         SQL statement only
                                          
=====================================

The part of the code looks like....

 begstmt := 'select unit_id,serial_num,su_prop_tag, category,mfr,model,'
||

 ''' <a href= /sysdept/owa/hwshow.full?p_id='''||rowid||'''>more</a>'''
||

              ' from hw ';

Does anyone have any suggestions...?? Received on Sun Sep 15 1996 - 00:00:00 CEST