rusbrown / plsql-utils

Automatically exported from code.google.com/p/plsql-utils
0 stars 0 forks source link

ms_ews_util_pkg.find_folders() ORA-20000: EWS for PL/SQL: ErrorInvalidIdMalformed: Id is malformed. #22

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Select * from table(ms_ews_util_pkg.find_folders('<enter a child folder of 
inbox>'));
2. ax_ews.get_folder('<enter a child folder of inbox>');
3.

What is the expected output? What do you see instead?
Expected output is a variable of type t_folder, being populated with the folder 
information.

I see the following error.

ORA-20000: EWS for PL/SQL: ErrorInvalidIdMalformed: Id is malformed.
ORA-06512: at "x.MS_EWS_UTIL_PKG", line 80
ORA-06512: at "x.MS_EWS_UTIL_PKG", line 271
ORA-06512: at "x.MS_EWS_UTIL_PKG", line 312
ORA-06512: at "x.MS_EWS_UTIL_PKG", line 522
ORA-06512: at line 11

What version of the product are you using? On what operating system?
I am using Oracle Release 11.2.0.1.0 Production on Windows 7(Test Environment)

Please provide any additional information below.

I have the error occur any time I change the folder

Original issue reported on code.google.com by ChadM.Ro...@gmail.com on 1 Oct 2013 at 1:35

GoogleCodeExporter commented 8 years ago
I've actually found the cause of this error. But can I request the error get 
trapped and thrown as a new error with a new message?

The cause of this was because I wasn't passing the parent folder with the child 
folder that I wanted details on. 

l_folder := 
MS_EWS_UTIL_PKG.get_folder(MS_EWS_UTIL_PKG.get_folder_id_by_name(p_folder_name, 
p_parent_folder_id));

That's what fixed it.

Original comment by ChadM.Ro...@gmail.com on 2 Oct 2013 at 2:22

GoogleCodeExporter commented 8 years ago

Original comment by thehunge...@gmail.com on 21 Nov 2013 at 2:59