MYSQL Loading data from XML file into table

Can pass xml AS parameter IN MYSQL STORED PROCEDURE? IF YES THEN HOW WITH AN EXAMPLE?

How can achieve the same in Oracle SQL ?? Not MySQL

please make video of passing an xml document with nested data tags

When execute these commands, I am getting this "Loading local data is disabled; this must be enabled on both the client and server sides".
I have done this also
SET GLOBAL local_infile = 'ON';

Sir I'm getting error as error 1290 server is running with --secure-file-priv option

I have a column, DATETIME and I am getting error as incorrect datetime format while importing, anything can you suggest please.

sir please explain XML PROCESSING IN ORACLE ...along with XML FUNCTION like XMLAGG /XMLELEMENT etc

Hi, i have an xml file (6GB) and i don't know how to get the tables, can you help me?

nice
I have a data on tally accounting which fetch through xml request. Kindly tell how to fetch data and link it to mysql or nodejs

Thanks for the video! How do we do this same operation but with an XML file that has metadata? Thanks!

Hello thanks for the video. I have a large xml file with over 100 fields. Can you do a video on how to auto create the table structure based on the XML file fields. Thanks.

Nice video, I am getting the error message that the used command is not allowed in this version of MySQL. Any ideas? Thanks

what if i use auto increment?