Why do I receive the error "??? Undefined function or variable 'getTheMetaData'." when I select certain tables using the Visual Query Builder in MATLAB?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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
Réponse acceptée
MathWorks Support Team
le 27 Juin 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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Structures dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!