two Question for PL/SQL?

显示全部楼层 · 2015-3-6 11:57:31

1.When run a procedure, I got a warning
" procedure ....executed with a compilation error.." what's meaning?

2. for nested table? if i wanna to create a new table based on this varray table, then use create table as select * from nested_table, I got an error:
" ... need to define the nested column....." what's meaning?
thx!

千问 · 2015-3-6 11:57:31

1: select * from user_objects where status = 'INVALID';
看看是不是有编译错误，仔细检查存储过程
2：你用了嵌套表？（或者varraycolumn？）
偶没有这个经验，恐怕不能直接象你这么做，还是先定义好结构吧

千问 · 2015-3-6 11:57:31

btw, how's u guys meeting?

千问 · 2015-3-6 11:57:31

本来以为你会去的，可惜啊

千问 · 2015-3-6 11:57:31

but...
flight ticket is too expensive

千问 · 2015-3-6 11:57:31

1. Normally I use "show error"to get exact error location. You may try it.
2. I don't know. If you solved problem, could you please show your code?
Thanks,

千问 · 2015-3-6 11:57:31

then can do insert.