[Home] [Help]
PACKAGE BODY: APPS.IEM_DATASTORE
Source
1 package body iem_datastore as
2 /* $Header: iemindsb.pls 120.2 2007/11/22 06:35:37 sanjrao ship $*/
3 /*======================================================================+
4 | Copyright (c) 1999 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +======================================================================+
8 | FILENAME: iemindsb.pls |
9 | |
10 | PURPOSE |
11 | Datastore procedure for iem_imt_index intermedia index. |
12 | ARGUMENTS |
13 | |
14 | NOTES |
15 | Usage: start iemindsb.pls apps |
16 | Arguments: |
17 | 1 - un_apps = apps user name |
18 | 2 - CTXSYS = ctxsys user name |
19 | HISTORY |
20 | 12-02-2003 rtripath Created.
21 +======================================================================*/
22 procedure get_imt_data(
23 p_rowid IN ROWID, x_clob IN OUT NOCOPY CLOB
24 ) is
25
26 BEGIN
27 select message_text into x_clob
28 from iem_imt_texts
29 where rowid=p_rowid;
30 EXCEPTION WHEN OTHERS THEN
31 null;
32 END get_imt_data;
33 end iem_datastore;