Why do I receive the error "??? Undefined function or variable 'getTheMetaData'." when I select certain tables using the Visual Query Builder in MATLAB?
1 view (last 30 days)
Show older comments
Why do I receive the error "??? Undefined function or variable 'getTheMetaData'." when I select certain tables using the Visual Query Builder in MATLAB?
I am having some problems using the Matlab Database toolbox to access an Oracle database. In the Visual Query builder, there are some tables from the database for which I cannot see the fields. When I select those table in the table list I get the following error messages:
??? Undefined function or variable 'getTheMetaData'.
Error in ==> D:\MATLAB6p5\toolbox\database\database\@cursor\columnnames.m
On line 46 ==> md = getTheMetaData(cursor.Fetch);
Error in ==> D:\MATLAB6p5\toolbox\database\vqb\querycallbacks.m
On line 749 ==> tmp = columnnames(ex);
??? Error while evaluating uicontrol Callback.
When I try to get the fields from the table using the following code:
db_connection = database('enrg','','') ;
query1 = 'select * from GEODE0310 where scn =1 and poste =1;' ;
cursor1 = exec(db_connection,query1) ;
message1 = cursor1.Message ;
message1
message1 =
[Oracle][ODBC][Ora]ORA-00942: table or view does not exist
Accepted Answer
MathWorks Support Team
on 27 Jun 2009
To resolve this problem, create a synonym for the table. Also, specify the table in lower case or enclose it in double quotes:
query2 = 'select * from "AREAS" ;';
0 Comments
More Answers (0)
See Also
Categories
Find more on Structures in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!