PACKAGE BODY: APPS.IEM_DATASTORE

Source

1 package body iem_datastore as
2 /* $Header: iemindsb.pls 120.4 2011/02/04 23:22:55 rtripath 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;