注册 登录
编程论坛 Oracle论坛

请教:在jsp中调用oracle函数出错.急!

jiangqf_79 发布于 2004-09-23 17:42, 3069 次点击

我在jsp页面中写了如下代码:

sqlStr = "select distinct substr(tcidpk,0,"+String.valueOf(level*2)+") as tcidpk," +" getStrByClass(tcname,"+String.valueOf(level)+") as tcname " +" from tclassification where tcidpk like 'St%' ";

运行时出现如下错误:java.sql.SQLException: ORA-06575: 程序包或函数 GETSTRBYCLASS 处于无效状态

请问高手我是不是哪里没有配置好?

1 回复
#2
nuhaizhengfeng2005-05-03 21:02
path 和classpath设置好了吗
1