Je ne parle pas français: Are French and German in danger of disappearing from Scottish schools?

French and German have been a mainstay of the Scottish curriculum for decades. But are they in danger of disappearing from our schools?