Hi There,

The following query sometime returns ORA-1403:

SELECT apptype, appupath, appuname, appvalue INTO :type, :upath,
:uname, :value INDICATOR :value_ind FROM pdm_appdata WHERE appuser =
'{Global}' AND apppath = '/DOCUMENT TYPE/CONCEPT' AND appname =
'HEARDER' AND apptype = 'VALUE';

The same query executes successfully from sqlplus prompt. Also we can
access the same data using cursors or using update query. This does not
happen everytime so not reproducible everytime. There will be only one
row fetched by this query. This table does not contain multiple rows
for this query at all. The solution is to restart the Oracle which is
not acceptable as it is production database. Please find the PL/SQL
code which executes this query below. There is a single row

Can anybody please response as soon as possible? Any help will be
appreciated.



int rel_appdata_get_value(char *usr, char *typ, char *pth,

char *upth, char *nam, char *unam, char *val)

{

EXEC SQL BEGIN DECLARE SECTION;

char user[APPUSER_LEN];

char type[APPTYPE_LEN];

char path[APPPATH_LEN];

char upath[APPPATH_LEN];

char name[APPNAME_LEN];

char uname[APPNAME_LEN];

char value[APPVALUE_LEN];

short value_ind;

EXEC SQL END DECLARE SECTION;



strcpy(type, "VALUE");

strcpy(user, usr);

strcpy(path, pth);

strcpy(name, nam);

EXEC SQL

SELECT

apptype,

appupath,

appuname,

appvalue

INTO

:type,

:upath,

:uname,

:value INDICATOR :value_ind

FROM pdm_appdata

WHERE appuser = :user

AND apppath = ath

AND appname = :name

AND apptype = :type;



if (SQLCODE == 0)

{

oraldchar(type, strlen(type));

strcpy(typ, type);

oraldchar(upath, strlen(upath));

strcpy(upth, upath);

oraldchar(uname, strlen(uname));

strcpy(unam, uname);

if (value_ind < 0)

value[0] = 0;

else

{

oraldchar(value, strlen(value));

strcpy(val, value);

}

}

return(make_sql_errcode(SQLCODE));

}

Thanks,
Milind