Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00320: the declaration of the type of this expression is incomplet (

kama021Jun 10 2009 — edited Jun 10 2009
this is a procedure i created in order to read and write to a directory. i get this error messages i don't what i am doing wrong here can you help me.
the error messages include
1.the declaration of the type of this expression is incomplet e
2. PLS-00201: identifier 'FTP.T_STRING_TABLE' must be declared
3.PLS-00201: identifier 'FTP.LOGIN' must be declared
4. PLS-00201: identifier 'FTP.LOGOUT' must be declared

PROCEDURE SP_TESTOMG_SIG
AS

l_conn UTL_TCP.connection;
l_list ftp.t_string_table;
BEGIN
l_conn := ftp.login ('172.20.100.240', '21', 'ftpuser', 'ftppassword');
ftp.LIST (p_conn => l_conn, p_dir => '/xch/signatures', p_list => l_list);
ftp.LOGOUT (l_conn);

IF l_list.COUNT > 0
THEN
FOR i IN l_list.FIRST .. l_list.LAST
LOOP
DBMS_OUTPUT.put_line (i || ': ' || l_list (i));
END LOOP;
END IF;
END;

Edited by: kama021 on Jun 10, 2009 1:37 AM
This post has been answered by 21205 on Jun 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2009
Added on Jun 10 2009
4 comments
2,751 views